Setting default worksheet in a workbook

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

Guest

I would like to know if it is possible to set a default page in a workbook so when the workbook is viewed, changed, and closed, it will open to a certain page each time.
 
Not without building a macro


On ThisWorkbook module paste this code

Change Sheet2 to your sheet name



Private Sub Workbook_Open()
Sheets("Sheet2").Activate
End Su
 
Back
Top