Edwin
Something like this in a worksheet module........
Private Sub Worksheet_Activate()
ScrollArea = "A1:M45"
End Sub
Or from J.E. McGimpsey........................
Private Sub Workbook_Open()
With Sheets("MyHelp")
.ScrollArea = .UsedRange.Address
End With
End Sub
This setting doesn't persist from session to session, so you have to
use the Workbook_Open event.
End J.E. quote.........................
Gord Dibben XL2002
