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?

Answer 1

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