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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to Fix Damaged Excel File That Won't Open? 3
Hyperlinks to a destination in google drive - help please 2
Excel cannot find or read file 5
Excel VBA - Problem with Closing Print Preview 0
Will not auto open .jpg 1
Hyperlink to a text file 1
Navigation linking within sheets, possible? 6
excel doc with hyperlinks 1

Back
Top