Set a worksheet to open

[BarrettM]

How can I set a specific worksheet to open when I open a workbook?

It always opens with whatever the last sheet was that I looked at.

 

[AJ]

In the Workbook area, you need something like...

Private Sub Workbook_Open()
Sheets("yoursheetname").Select
End Sub

Rgds
AJ

 

[BarrettM]

Gosh I feel such a dork, I could not see the workbook area.

Thanks anyway

 

[robfo0]

Put this code (modify for your sheet name) in the "ThisWorkbook" section in excel VB:

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

 

[mcilrja]

Is there a command line for opening specific worksheets in a workbook when opening excel. You can specify in icon properties a workbook to open. Can you also tell excel which worksheet of the workbook to open as well?