Microsoft Office Tutorials and References
In Depth Information
Keeping Others from Tampering with Worksheets
3. Enter a password in the Password to Unprotect Sheet box if you want
only people with the password to be able to unprotect the worksheet
after you protect it.
4. On the Allow All Users of This Worksheet To list, select the check box
next to the name of each task that you want to permit others to do.
For example, click the Format Cells check box if you want others to be
able to format cells.
Deselect the Select Locked Cells check box to prevent any changes from
being made to the worksheet. By default, all worksheet cells are locked,
and by preventing others from selecting locked cells, you effectively
prevent them from editing any cells.
5. Click OK.
If you entered a password in Step 3, you must enter it again in the
Confirm Password dialog box and click OK.
To unprotect a worksheet that you protected, go to the Review tab and click
the Unprotect Sheet button. You must enter a password if you elected to
require others to have a password before they can unprotect a worksheet.