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.
--
Gary''s Student - gsnu200776


"Mary Ann" wrote:

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 dont have to scroll again on each sheet.