open workbook to specific sheet
 

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.

open workbook to specific sheet
 

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

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

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Mr E" wrote:

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.