Link to home
Start Free TrialLog in
Avatar of brothertruffle880
brothertruffle880Flag for United States of America

asked on

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
User generated image
Avatar of Steven Harris
Steven Harris
Flag of United States of America image

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.
ASKER CERTIFIED SOLUTION
Avatar of Jacques Bourgeois (James Burger)
Jacques Bourgeois (James Burger)
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of brothertruffle880

ASKER

F1 offers somewhat useful descriptions but rarely offer real-world insights.