May 18 2021 08:47 AM - last edited on Nov 09 2023 11:10 AM by
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
May 18 2021 08:49 AM
@KennyG2021 What prevents you from saving it from the dashboard?
May 18 2021 09:41 AM
@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.