Excel File Opening Via Hyperlink

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

Guest

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.
 
Put this one line Macro in the ThisWorkbook code area:

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