» Limiting the Movement in a Protected Sheet in 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