Forum Discussion
all worksheets in a workbook should open at the same location
Hello everybody! This is an issue that's bugged me for years. My team works with multiple workbooks, each containing numerous pages/worksheets. How can I make each page open at the same location (cel...
This could be done with a sheet level macro that runs on sheet activation (When you go to the sheet). I'm not crazy about this solution because it would require your workbook be an XLSM and then you must get everyone up to speed on enabling macros and such. Another approach would be to use a keyboard shortcut (Ctrl Home) to navigate quickly to the top of the sheet.
Thank you! Just the mention of macros would send my colleagues screaming into the street so until some other magical solution comes up Ctrl Home will have to do! Thanks again 🙂