Open file at specific sheet?

Is it possible to ensure that when opening a shared file, that it automitically opens at a specific worksheet?

Cheers, Teeb

Sure, Teeb - In ThisWorkbook object try this code:

Private Sub Workbook_Open()
ThisWorkbook.Worksheets(3).Activate
End Sub

The above will open the workbook to sheet three.

Take care,
Tamara

Originally Posted by teeb

Is it possible to ensure that when opening a shared file, that it automitically opens at a specific worksheet?

Cheers, Teeb