block scrolling

C

Claude

Hi all
Is is possible to "freeze" an excel sheet in such a way
that the user can only scroll around in a certain
delimited area?
Thanks!
 
D

Dave Peterson

You could have a macro that does some fancy protecting--put it in your auto_open
or workbook_open event:

Option Explicit
Sub auto_open()
With Worksheets("sheet1")
.Protect Password:="hi"
.EnableSelection = xlUnlockedCells
.ScrollArea = .Range("c9:d122").Address(external:=True)
End With
End Sub


Excel won't remember these settings after you close it and reopen the workbook
(that's why it's in auto_open).
 
Top