Open "master worksheet"

  • Thread starter Thread starter Amanda
  • Start date Start date
A

Amanda

Hi all -

I have a workbook with 15 worksheets in it. I have one
worksheet that acts as a table of contents for the other
worksheets. I would like to know how to get excel to
open that worksheet first everytime instead of opening
the last worksheet edited. In otherwords, when I
doubleclick on the .xls file, the first thing I want to
see is the master worksheet which is the table of
contents.

Thanks.

Amanda
 
Amanda, open this particular workbook, press Alt + F11,
in the project pane to the left find your workbook and double
click on ThisWorkbook, in the main window that opens paste

Private Sub Workbook_Open()
Application.Goto Worksheets("Master").Range("A1"), True
End Sub

(replace Master with the name of your master sheet)

press Alt + Q to close the VBE and save the workbook
 
Back
Top