how to embed print instruction portrait landscape in excel

[smhusain]

Is there a way to embed Portrait and landscape instructions in an excel
spreadsheet so that a single print instruction will print a speadsheet in
accordance with such instructions.

 

[Gary''s Student]

Easy.

You need to create a BeforePrint workbook event macro. The macro would
contain all the print setup commands.

 

[Dave Peterson]

I'd record a macro when I did it the way I wanted.

Then I'd rerun that macro whenever I needed this functionality.

In fact, if it were a common requirement, I'd plop a button from the Forms
toolbar (not the control toolbox toolbar) and assign this macro to that button.