» Limiting the Movement in a Protected Sheet
CATEGORY - Excel Security - Protection
VERSION - All Microsoft Excel Versions
1. Click the Properties icon .
OR
From the Control Toolbox toolbar, click the Properties icon.
2. There are three options in EnableSelection:
xlNoRestrictions: In a protected sheet, selection is allowed for both locked and unlocked cells.
xlUnLockedCells: In a protected sheet, selection is allowed for unlocked cells only (in the screenshot below a cell containing a formula cannot be selected).
xlNoSelection: In a protected sheet, selection is not allowed for either locked or unlocked cells.

Book Store:
Recommended Books:
- How to Pay Zero Taxes (Annual)
- Analyzing Markets, Products, and Marketing Plans
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- The Fall of Advertising and the Rise of PR
- Microsoft Excel 2002 Formulas (With CD-ROM)
No comments have been submitted.

