Excel 2010 VBA - Scroll area Property versus Protecting a range

How is enabling the scroll area better/worse/different than protecting the worksheet area  outside of the scroll area.  I just tested the scroll area property (see graphic) and it seems to disallow data entry outside of the scroll area
err
brothertruffle880Asked:
Who is Participating?
 
Jacques Bourgeois (James Burger)PresidentCommented:
When you set a ScrollArea, cells outside of the ScrollArea cannot be selected.

When you use protection, you let the user select cells, but he cannot make changes to them.

For all your 3 questions, there is a simple way to get an answer without having to wait for an expert to respond: F1 on the method or property for which you need details.
0
 
Steven HarrisPresidentCommented:
Like other Excel protection settings, this is just a deterrent rather than an actual security feature.  This can be overrode in a number of ways.
0
 
brothertruffle880Author Commented:
F1 offers somewhat useful descriptions but rarely offer real-world insights.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.