Open file to specific sheet

Posted by John on October 26, 2001 7:28 AM

I want to open a file and be at sheet1 (menu) everytime no matter where the cell pointer was when last saved. This way every user starts at the menu sheet when the file is opened.

Thank you.

Posted by Juan Pablo on October 26, 2001 7:31 AM

Put in the workbook module

Private Sub Workbook_Open()
Sheets("Menu").Activate
End Sub

Juan Pablo

Posted by John on October 26, 2001 8:19 AM

Thank you.