Jun 13 2023 10:36 AM
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 (cell B2, for example) regardless of where it last closed? Some of these worksheets are quite large and it's aggravating to have to scroll back to the start each time I open a worksheet. Same goes for the size of the worksheet. Thanks!!!
Jun 13 2023 03:12 PM
Jun 14 2023 06:43 AM
Thanks for your response. Let me clarify: I have a workbook with 7 worksheets. All are similarly formatted. #1 is the Master, containing all data - each line pertains to a different project. #2 - #6 draw specific data from the master depending upon the focus of the sheet. I shift between worksheets throughout the day and when finished, close/save the entire workbook.
For example, when I'm working in the Master, let's say on line #10. When I open other worksheets, I would like them to open at line #10. It's frustrating to open a sheet and have it open to line #57 (for example).
Jun 14 2023 08:13 AM - edited Jun 14 2023 08:14 AM
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.
Jun 14 2023 08:30 AM