Macro to Save Active Sheet as PDF

[michaeldh]

Hi,

I was hoping someone might be able to provide some sample code that can pdf the active sheet a user is on.

It might be that a user clicks a button and Excel uses Adobe to pdf the sheet.

Any tips would be appreciated.

Thanks.

 

[Joe4]

You first obviously need to have Adobe Acrobat or some other PDF Writer software.

Then, simply turn on the Macro Recorder and record yourself printing the ActiveSheet to PDF. This will give you the code you need for your macro. You can then attach the code to a command button.

 

[Joe Was]

Look at this link:


http://www.mrexcel.com/board2/viewtopic.php?t=222381