comand button that prints area to file automatically?

**Jeff18** · 01-08-2010, 12:47 PM

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** · 01-08-2010, 01:10 PM

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

**Jeff18** · 01-08-2010, 01:24 PM

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