comand button that prints area to file automatically?

[Jeff18]

Anyone have a command button that they can share that I can insert? I'd like to be able to click a command button on a worksheet that prints the print area of that worksheet automatically to a newly saved file location. Even better if it saved a new pdf file to a specified location?

Thanks!
Jeff

[royUK]

You need pdf software to create pdf's, unless you have Excel 2007.

[Jeff18]

I do have adobe software installed and couldprint to a pdf by going thru File:Print, however, I'd like to have a command button do this for me right in a worksheet.

Thanks

[royUK]

See this earlier post.

See http://excel-it.com/add_button.htm