Auto open a spreadsheet

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have a worksheet with a main page with hyperlinks to 12
other pages within the workbook, I need the menu page to
open by default when you open the spreadsheet.
 
You would need a macro that runs when you open the workbook


there are 2 methods to acheive this


place this code on ThisWorkbook module - changing sheetname

Private Sub Workbook_Open()
Sheets("YourMasterSheetNameHere").Activate
Range("a1").Select
End Sub


or

Place this code on a normal module sheet - changing sheetname

Sub Auto_Open()
Sheets("YourMasterSheetNameHere").Activate
Range("a1").Select
End Su
 
Back
Top