Solved

Excel 2010 VBA - Scroll area Property versus Protecting a range

Posted on 2013-11-09
3
498 Views
Last Modified: 2013-11-11
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
Comment
Question by:brothertruffle880
3 Comments
 
LVL 18

Expert Comment

by:Steven Harris
ID: 39636309
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
 
LVL 40

Accepted Solution

by:
Jacques Bourgeois (James Burger) earned 500 total points
ID: 39636445
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
 

Author Comment

by:brothertruffle880
ID: 39639528
F1 offers somewhat useful descriptions but rarely offer real-world insights.
0

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

772 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question