Print to PDF

[mma3824]

Hello,

I am trying to insert a command button to have staff print a section of a excel sheet template to a pdf. I have been able to set up the command button along with a basic print to PDF macro.

The additional items I would like to add is to have an input box show that would have the staff name the saved PDF and also only print the range of A1 to G40 to the PDF.

Any help would be a great assist!

Thank you,
Nick


Currently I have this for the code:

Activesheet.ExportAsFixedFormat Type:=xlTypePDF

[jolivanes]

Please Login or Register  to view this content.

[mma3824]

Thanks! This exported did everything I was looking for except for one item. The print area. It printed the whole active sheet and not the section only of A1:G40. What do I need differently to only print that active section?

Thanks,
Nick

[mma3824]

Never mind. I see it is working great!

Thanks!