link two window views

N

nt8jbwu02

I have an excel spread sheet with two windows opened so that I can see
two different sheets. How can I link them so that the rows are lined
up so that if I scroll down to a particular row, the same row is
scrolled to in the other sheet?

Thanks.
 
D

Dave Peterson

You can use this code from Jim Rech to sync (and unsync) the windows.

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

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Top