Excel File Opening Via Hyperlink

M

Me

What do I need to do within an Excel document to have it open in print
preview mode when the Intranet link to this file is clicked?

Thank you.
 
G

Gary''s Student

Put this one line Macro in the ThisWorkbook code area:

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