ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   pages open is wrong positions (https://www.excelbanter.com/excel-discussion-misc-queries/226254-pages-open-wrong-positions.html)

rwfster

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

dlw

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