default print orientation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I would like to change the default print orientation in excel to be landscape instead of portrait, to save time in formatting reports I am generting from great plains dynamics into excel format. I open the reports in excel and then I have to change the orientation before printing them. It would be great to save that step. Can anyone help? Thanks, Lisa
 
One approach:
In a standard module enter:

Sub PrintLandScape()
With ActiveSheet
.PageSetup.Orientation = xlLandscape
.PrintPreview ' or just Print
End With
End Sub

Add a new icon to your toolbar and assign this macro to it..
HTH


Lisa Williams said:
Hi, I would like to change the default print orientation in excel to be
Click to expand...
landscape instead of portrait, to save time in formatting reports I am
generting from great plains dynamics into excel format. I open the reports
in excel and then I have to change the orientation before printing them. It
would be great to save that step. Can anyone help? Thanks, Lisa
 
For new workbooks (not existing), you can create a template and use that.

If you want it for every new workbook, set up a new workbook the way you want
it.

print settings, headers/footers/fonts, number of sheets, everything...

Then save it as Book.xlt (as a template) in your XLStart folder.

You can also create a template for new worksheets added to existing workbooks.
Call it sheet.xlt and save it in the same XLStart folder.

(Use windows start button|find (or search) to look for your XLStart folder.)
 
Back
Top