Open specific Worksheet Excel on 97-2003 Worksheet

Question

I want to open a specific worksheet every time and not the one which was saved last. I have the following macro in a Microsoft Office Excel 97-2003 Worksheet (This Workbook --> Workbook, Open):

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

But apparently this doesn't work. How can I fix this?

Solution

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

Comments

[Piyush Mattoo]

Tried that option already doesn't work. Thanks for the recommendation though.

[akd]

The above code works for me. How are you setting up your macro?

[Piyush Mattoo]

I clicked on Alt+F11 -> Clicked on 'This Workbook' -> Chose 'Workbook' on left dropdown and 'Open' on right drop down -> Have pasted above code there. Note that am using Microsoft Office Excel 97-2003 Worksheet. Please let me know in case am missing something anywhere.

[akd]

Right click on a file in your project and insert a module. Then paste your code in there. When you run that, it should work. Then to get it to work automatically, you would have to tell the workbook to run the macro when the file opens.