Scroll all sheets to same row

[Mary Ann]

I have a spreadsheet with say 10 worksheets in it. Each worksheet is laid
out the same way.

I regularly need to scroll to the same place in each sheet, lets say row
100. Is there a way for me to scroll to row 100 on the first sheet I look at
and then when I go to the next sheet, it is already showing row 100 on screen
so I don’t have to scroll again on each sheet.

 

[Gary''s Student]

In a standard module insert:

Public rrow As Long

In the worksheet code area for Sheet1, insert:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
rrow = Target.Row
End Sub

In the worksheet code area for all the other sheets, insert:

Private Sub Worksheet_Activate()
Application.Goto Cells(rrow, "A"), scroll:=True
End Sub

Whenever you "leave" Sheet1, Excel will remember the row number and go to
the same row on the newly selected sheet.

 

[Mary Ann]

Ah, I forgot to mention I'm not familiar with coding and wanted a solution
which "ordinary" users would be able to use, so this is not going to do it
for me. Thank you for your reply though.

Does anyone else have a solution which does not involve coding? I and the
other users interested in this use 2003.