Open Workbook on Specific sheet without macro

%3CLINGO-SUB%20id%3D%22lingo-sub-2364914%22%20slang%3D%22en-US%22%3EOpen%20Workbook%20on%20Specific%20sheet%20without%20macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2364914%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20a%20workbook%20that%20has%2010%20sheets.%20One%20sheet%20is%20called%20Dashboard.%20Every%20time%20I%20open%20the%20file%2C%20it%20opens%20on%20the%20sheet%20where%20I%20last%20saved.%20I%20would%20like%20it%20to%20open%20on%20the%20Dashboard%20sheet.%20There%20are%20a%20couple%20of%20mentions%20on%20google%20about%20this%20but%20it%20needs%20VB%20code.%20My%20company%20has%20banned%20code%20and%20macros%20and%20wont%20let%20a%20file%20be%20saved%20as%20a%20macro%20enabled%20workbook.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20using%20Office%20365%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20of%20any%20other%20way%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%2C%20Kenny%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2364914%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2364931%22%20slang%3D%22en-US%22%3ERe%3A%20Open%20Workbook%20on%20Specific%20sheet%20without%20macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2364931%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1056913%22%20target%3D%22_blank%22%3E%40KennyG2021%3C%2FA%3E%26nbsp%3BWhat%20prevents%20you%20from%20saving%20it%20from%20the%20dashboard%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2365201%22%20slang%3D%22en-US%22%3ERe%3A%20Open%20Workbook%20on%20Specific%20sheet%20without%20macro%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2365201%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3BThanks%20for%20your%20reply.%20There%20are%2030%20to%2040%20people%20accessing%20and%20updating%20the%20workbook%2C%20although%20I%20have%20said%20on%20many%2C%20many%20occasions%2C%20the%20other%20users%20regularly%20forget%20to%20save%20from%20the%20Dashboard%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.