Open in print preview

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

Guest

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

Thanks.
 
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
 
It worked perfectly.

Thank you!

Gord Dibben said:
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
Click to expand...
 
Back
Top