Syncing spreadsheet windows

G

gjcase

I saw a note from Dave Peterson in a recent post on window splits. Dav
provided code to keep two windows synced. The code provided works fin
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 o
separate worksheets or spreadsheets synced?

---Glen
 
D

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.
 
Top