Setting All Worksheets To The Same Scroll Position

I have a multiple worksheet Excel workbook and want to be able to move to the
same cell automatically across each worksheet (ideally with the same window
position). How can I fix this?

Not sure if this is what you mean but on
http://www.auditexcel.co.za/tips%20and%20tricks.html you can see how to
change multiple sheets at the same time. Dangerous though if the sheets are
exactly the same structurally.

"wormdazzler" wrote:

> I have a multiple worksheet Excel workbook and want to be able to move to the
> same cell automatically across each worksheet (ideally with the same window
> position). How can I fix this?

Doesn't help if you don't have it but Excel 2003 has this functionality
under the window menu. (Compare side-by-side)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS


"wormdazzler" <[email protected]> wrote in message
news:[email protected]...
>I have a multiple worksheet Excel workbook and want to be able to move to
>the
> same cell automatically across each worksheet (ideally with the same
> window
> position). How can I fix this?