Forum Discussion
Open Workbook on Specific sheet without macro
Hi, I have a workbook that has 10 sheets. One sheet is called Dashboard. Every time I open the file, it opens on the sheet where I last saved. I would like it to open on the Dashboard sheet. There are a couple of mentions on google about this but it needs VB code. My company has banned code and macros and wont let a file be saved as a macro enabled workbook.
I am using Office 365
Does anyone know of any other way to do this?
Many thanks, Kenny
2 Replies
KennyG2021 What prevents you from saving it from the dashboard?
Riny_van_Eekelen Thanks for your reply. There are 30 to 40 people accessing and updating the workbook, although I have said on many, many occasions, the other users regularly forget to save from the Dashboard sheet.
