Open Workbook on Specific sheet without macro

New Contributor

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.