Macro to print pdf with certain print settings

[ChrisLN]

Hi all

I need a macro that lets me print an excel worksheet to pdf with specific print settings ("filename and save location" pop-up follows as normal)

Example excel 2010:

---Settings---
*Print active sheet*
*Collated*
*Landscape orientation*
*A4*
*Normal margins*
*Fit all columns to one page*

as well as PrintTitleRows = "1:2"

In advance, thanks!

Kind regards Chris

[Kenneth Hobson]

IF you record a macro, you will get the syntax. See PageSetup options and such. e.g.

Please Login or Register  to view this content.