open workbook to specific sheet

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

Gary Brown

In the 'ThisWorkbook' module, put the following code (adapted to the
worksheet you want)...

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