open workbook to specific sheet

  • Thread starter Thread starter Mr E
  • Start date Start date
M

Mr E

I am trying to force excel to open to the same workesheet each time the work
book is opened. regardless of where it was last saved. Is this possible? If
so, how would you accomplish this.
 
In the 'ThisWorkbook' module, put the following code (adapted to the
worksheet you want)...

Private Sub Workbook_Open()
Worksheets("Sheet1").Activate
End Sub
 
Back
Top