Solved

Excel 2010 VBA - Scroll area Property versus Protecting a range

Posted on 2013-11-09
3
495 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
It was really hard time for me to get the understanding of Delegates in C#. I went through many websites and articles but I found them very clumsy. After going through those sites, I noted down the points in a easy way so here I am sharing that unde…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

746 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now