Syncing spreadsheet windows

[gjcase]

I saw a note from Dave Peterson in a recent post on window splits. Dave provided code to keep two windows synced. The code provided works fine if both windows are the active workbook:

Option Explicit
Sub SyncWindows()
Windows.Arrange ActiveWorkbook:=True, _
synchorizontal:=True, syncvertical:=True
End Sub

Question I have is whether there is a similar method to keep windows on separate worksheets or spreadsheets synced?

---Glenn

[Dave Peterson]

From xl2003's help for .arrange:

SyncHorizontal Optional Variant. Ignored if ActiveWorkbook is False or
omitted. True to synchronize the windows of the active workbook when scrolling
horizontally. False to not synchronize the windows. The default value is False.

SyncVertical Optional Variant. Ignored if ActiveWorkbook is False or omitted.
True to synchronize the windows of the active workbook when scrolling
vertically. False to not synchronize the windows. The default value is False.


So it doesn't look like that this'll work for you.

gjcase wrote:
>
> I saw a note from Dave Peterson in a recent post on window splits. Dave
> provided code to keep two windows synced. The code provided works fine
> if both windows are the active workbook:
>
> Option Explicit
> Sub SyncWindows()
> Windows.Arrange ActiveWorkbook:=True, _
> synchorizontal:=True, syncvertical:=True
> End Sub
>
> Question I have is whether there is a similar method to keep windows on
> separate worksheets or spreadsheets synced?
>
> ---Glenn
>
> --
> gjcase
> ------------------------------------------------------------------------
> gjcase's Profile: http://www.excelforum.com/member.php...o&userid=26061
> View this thread: http://www.excelforum.com/showthread...hreadid=522874

--

Dave Peterson