Macro to print pdf with certain print settings

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