Excel Print Page setup macro...
 

Hi Guys & Girls,

I am trying to create a multistage macro that takes the preselected print area of a worksheet and formats the page settings to suit. I have working versions for A3/A4 sheets in both landscape & portrait format - But I would like to have the one button that prompts the user for "A3 or A4" and "portrait or Landscape" before exectuting the appropiate Macro.

This way I can format each sheet of the workbook to the right orientaion & printer very quickly (lots of existing data to recompile!) with only a few button pushes. Any ideas or methods?

Cheers

Harvey