Thread: Loading a specific sheet in a workbook on opening Excel

LEEP2008,

I have two variations on your request to activate a specific worksheet when you open your workbook (no matter what worksheet was active the last time you saved the workbook).

1. Activate worksheet name "Sheet1":

Code:

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

2. Activate the first worksheet in your workbook, not the name of the worksheet (the way your tabs are in order from left to right):

Code:

Private Sub Workbook_Open()
 Sheets(1).Activate
End Sub

Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).

1. Copy the above code of your choice, by highlighting the macro code and pressing the keys CTRL + C
2. Open your workbook
3. Press the keys ALT + F11 to open the Visual Basic Editor
4. And, paste the copied code into VBAProject, Microsoft Excel Objects, ThisWorkbook (on the right pane) by pressing the keys CTRL + V
5. Press the keys ALT+Q to exit the Editor, and return to Excel


Then save and close the workbook with the active sheet not the sheet that you want to be active upon opening your workbook.

Then open the workbook again.