Auto open a spreadsheet

[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.

 

[mudraker]

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 Autpen()
Sheets("YourMasterSheetNameHere").Activate
Range("a1").Select
End Su

 

[Guest]

Thankyou that works.