restructing navigation

[Edwin Merced]

Is there a way to restrict a user to an established range using macros?

 

[Gord Dibben]

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