开发者

Open specific Worksheet Excel on 97-2003 Worksheet

开发者 https://www.devze.com 2023-02-06 18:02 出处:网络
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

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?


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

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号