paper size via formula

[jeffcox]

Hi All,

I have a template that needs to be printed on A4 and A3 ad-hoc, the template has about 10 different sheets and when printing from the template you may only need certain sheets to be printed.

At the moment the tamplate is made and scaled for A4, is there a way to make a drop down list on the first sheet to change the print size and scale for the whole workbook or is it a case of making a macro for this?

Thanks Jeff

[RobertMika]

Macro I'm affraid.