Syncing spreadsheet windows
 

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

Syncing spreadsheet windows
 

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