Specify what worksheet to open first
 

Hi,
Does anyone know how I can control what worksheet to open first when
starting excel? I have several worksheets in a workbook but every time I
close out of it and reopen it, it opens with the same worksheet. I want to
specify what worksheet to open first.

Specify what worksheet to open first
 

Michele,

You can use the workbook's open event:

Private Sub Workbook_Open()
ThisWorkbook.Worksheets("Sheet1").Select
End Sub

Of course, change the sheet name to whatever is appropriate. Place the code in the codemodule of
the ThisWorkbook object.

HTH,
Bernie
MS Excel MVP


"Michele" wrote in message
...
Hi,
Does anyone know how I can control what worksheet to open first when
starting excel? I have several worksheets in a workbook but every time I
close out of it and reopen it, it opens with the same worksheet. I want to
specify what worksheet to open first.