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" <(E-Mail Removed)> wrote in message
news:18012380-1020-4655-9480-(E-Mail Removed)...
> 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

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.)



Lisa Williams wrote:
>
> 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

--

Dave Peterson
(E-Mail Removed)