Open in print preview

[Me]

How do I get an Excel document to open directly to print preview? Can this
even be done?

Thanks.

 

[Gord Dibben]

You would have to do this using workbook_open code.

Private Sub Workbook_Open()
ActiveWindow.SelectedSheets.PrintPreview
End Sub

Right-click on the Excel logo left of "File" on the menu or on the logo at left
end of title bar if not maximized.

Select "View Code".

Copy/Paste the above code into that modulw.

Save/close and re-open.


Gord Dibben MS Excel MVP

 

[Me]

It worked perfectly.

Thank you!

You would have to do this using workbook_open code.

Private Sub Workbook_Open()
ActiveWindow.SelectedSheets.PrintPreview
End Sub

Right-click on the Excel logo left of "File" on the menu or on the logo at left
end of title bar if not maximized.

Select "View Code".

Copy/Paste the above code into that modulw.

Save/close and re-open.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

Glad to hear.

Gord

It worked perfectly.

Thank you!