Dave, I want to thank you for your help so far.
I did copy and paste the formula you sent me and changed the sheet names to
there correct names in both spots. After all is copied and changed, do I x
out of the box? And or how do I activate it. Also on top, it has 2 drop down
boxes, one box has general in it and the other has declarations.

"Dave Peterson" wrote:

You can try this against a copy of your workbook (just in case....).

Open excel and open your workbook.
rightclick on the excel icon to the left of the File|Edit|view|... menubar.

select view code.
Paste this code (I like it better than the first suggestion) into the codewindow
that just opened up (righthand side window)

Option Explicit
Dim CurRow As Long
Dim CurCol As Long
Dim ActCellAddr As String
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Select Case LCase(Sh.Name)
Case Is = "sheet1", "sheet2", "sheet4"
If CurRow 0 Then
With Application
.EnableEvents = False
.Goto Sh.Cells(CurRow, CurCol), scroll:=True
Sh.Range(ActCellAddr).Select
.EnableEvents = True
End With
End If
End Select
End Sub
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Range)
Select Case LCase(Sh.Name)
Case Is = "sheet1", "sheet2", "sheet4"
CurRow = ActiveWindow.ScrollRow
CurCol = ActiveWindow.ScrollColumn
ActCellAddr = ActiveCell.Address
End Select
End Sub

Change the names in this line:
Case Is = "sheet1", "sheet2", "sheet4"
to match the sheets that should be affected -- in both spots, too. And make
sure you use all lower case letters.







billy boy wrote:

Dave, thanks for your response. I do not know anything about macros, and I
was reading about them and still lost. Thanks again, I will keep trying.

"billy boy" wrote:

Is it possible to have worksheets scroll at the same time? For example when
you scroll down to line 100 on sheet 1 and then you go to sheet 2 or 3 or 4
that sheet will be on line 100 also?


--

Dave Peterson