|  

» Limiting the Movement in a Protected Sheet in Excel 2007

CATEGORY - Excel Editing VERSION - Microsoft Excel 2007
To limit the movement in a protected sheet (for this example, protect the cells containing formulas):
1. Press Alt+F11 to open the VBA Editor.
2. Double click a Module Sheet, press F4 to open the Properties dialog box.
3. In EnableSelection find three options:
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.
xlNoSelection: In a protected sheet, selection is not allowed for either locked or unlocked cells.
Screenshot // Limiting the Movement in a Protected Sheet in Excel 2007
Limiting the Movement in a Protected Sheet in Excel 2007


Rate This Tip
12 34 5
Rating:     Views: 3281
No comments have been submitted.
Click here to post comment
For Registered Users
Name
Comment Title
Comments