Synchronized Scrolling

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

glen.e.mettler@lmco.com - 15 Aug 2007 15:07 GMT

using 2003. I can synchronize the scroll on 2 spreadsheets by using
"Windows.CompareSideBySideWith"
I need to synchronize three sheets (ie "Last Month", "Current Month",
and "Delta"). Is there a way to do that?

Glen

Reply to this Message

Jim Rech - 15 Aug 2007 15:35 GMT

>>I need to synchronize three sheets

Two windows only for this feature. It is possible to scroll more than 2
windows using a feature that used to be part of the UI but is now accessible
only by macro (the Windows.Arrange method). However the windows have to all
have to be for the same worksheet so it wouldn't help you here.

Signature

Jim

| using 2003. I can synchronize the scroll on 2 spreadsheets by using
| "Windows.CompareSideBySideWith"
| I need to synchronize three sheets (ie "Last Month", "Current Month",
| and "Delta"). Is there a way to do that?
|
| Glen

Reply to this Message

Max - 16 Aug 2007 06:57 GMT

Try also this link:
http://scriptorium.serve-it.nl/view.php?sid=8

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> using 2003. I can synchronize the scroll on 2 spreadsheets by using
> "Windows.CompareSideBySideWith"
> I need to synchronize three sheets (ie "Last Month", "Current Month",
> and "Delta"). Is there a way to do that?
>
> Glen

Reply to this Message

Rate this thread: