Macro to go to a specific worksheet

Place the code below into the code module ThisWorkbook.

Andreas.

Private Sub Workbook_Open()
  Worksheets("MySpecificSheetName").Activate
End Sub

super fast reply: thank you. will do so immediately.

Ken

Didn't work. The sheet name on the Tab is BUDGETF-MONTHLY EXPENSES 2025. I saved the workbook with a different worksheet showing, then,

I tried in lower case, with and without the hyphen, with and without the spaces between words. Still opens to a different worksheet.

Didn't work. The sheet name on the Tab is BUDGETF-MONTHLY EXPENSES 2025. I saved the workbook with a different worksheet showing, then,

I tried in lower case, with and without the hyphen, with and without the spaces between words. Still opens to a different worksheet.

Code is:-

Private Sub Workbook_Open()

  Worksheets(2).Select

End Sub

Note how the number 2 corresponds to the name that you’ve given to your Worksheet (see image below). 

 ![](https://learn-attachment.microsoft.com/api/attachments/d9335158-1bda-4124-8be3-5c18f19f1ed4?platform=QnA

Didn't work. The sheet name on the Tab is BUDGETF-MONTHLY EXPENSES 2025. I saved the workbook with a different worksheet showing, then,

I tried in lower case, with and without the hyphen, with and without the spaces between words. Still opens to a different worksheet.

Means the code did not run. If you tried it without spacing (or the sheet name misspelled) you would get a RTE 9!

It's up to you to enable your macros.

Enable or disable macros in Office files - Office Support

Andreas.