Open Workbook to specific sheet without using VBA

[jars121]

Hi everyone,

I've got an annoying issue. I've got a script that hides all sheets apart from a 'Welcome' page, which works nicely. However, when a user opens the workbook for the first time, they are prompted with the 'Enable Macros' warning. As the macros haven't yet been enabled, the VB controlled 'Welcome' page isn't displayed, it's the page that was last opened. As each user only has access to their own page (governed by username/password on the Welcome page), it's not ideal that a user can open up workbook and find themselves on someone else's page.

Is it possible to specify which sheet to open on without use macros? A previous revision of my code did exactly that, but due to other reasons I had to modify it, and now it opens on the previously opened page.

 

[jars121]

I think I just answered my own question, although it may not be the best solution. As part of my Workbook.BeforeClose() sub, I've specified for the Welcome sheet to be selected, and for all other sheets to be hidden prior to the final save, once the user has closed the program. It's not glamourous, but it works!