![]() |
pages open is wrong positions
I use a large excel 2003 spreadsheet that has 6 worksheets. Sometimes the
pages open on different rows, i.e.: page 1 opens on row 4, page 2 opens on row 16, page 3 opens on row 97 etc. It is imperative that data is inputted in the same row across all worksheets. Is there any way to sync all worksheets to the same row so that all pages would open to the same row? Thanks in advance for the help. -- rwfster |
pages open is wrong positions
they open to wherever they were the last time it was saved, you may want a
small macro to "home" everything when the sheet is opened. "rwfster" wrote: I use a large excel 2003 spreadsheet that has 6 worksheets. Sometimes the pages open on different rows, i.e.: page 1 opens on row 4, page 2 opens on row 16, page 3 opens on row 97 etc. It is imperative that data is inputted in the same row across all worksheets. Is there any way to sync all worksheets to the same row so that all pages would open to the same row? Thanks in advance for the help. -- rwfster |
All times are GMT +1. The time now is 03:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com