Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 523
  • Last Modified:

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
0
brothertruffle880
Asked:
brothertruffle880
1 Solution
 
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
 
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
 
brothertruffle880Author Commented:
F1 offers somewhat useful descriptions but rarely offer real-world insights.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now