ScrollArea

[Hmm]

Has anyone used the scrollarea property instead of cells
protection. No one has ever mentioned it. Basically you
enter the rage of cells you want accessible. The only
thing is that you cannot scroll out of the bound area.

View the worksheet in VBE for the property

 

[JE McGimpsey]

I've used it before, but I find it's of limited utility since it doesn't
stop the user from selecting a cell outside the scroll area using the
name box.

It's also limited in that it only is in effect for that Excel session -
if you close and reopen the file, the restriction is lifted. You can
work around this if you put the command in the Workbook_Open() event
macro.

 

[Dave Peterson]

And another thing that I hate is that you can't select a whole column or row.

If you're applying formats, then it becomes more of a pain to get things done.