Change or remove protection of worksheet or workbook elements

Change protection

ShowChange the protection or password for a worksheet

  1. Switch to the protected worksheet.
  2. On the Tools menu, point to Protection, and then click Unprotect Sheet.
  3. If prompted type the current password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.), and then click OK.
  4. On the Tools menu, point to Protection, and then click Protect Sheet.
  5. In the Allow all users of this worksheet to list, make any changes you want to the elements users will be able to change.
  6. Type the password in the Password to unprotect sheet box.
  7. Click OK, and if prompted retype the password.

 Note   It is very important that you remember the password that you set. Without the password, there is no way to unprotect the workbook or worksheet.

 Important   Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.

ShowChange the password for a range

  1. Switch to the protected worksheet.
  2. On the Tools menu, point to Protection, and then click Unprotect Sheet.
  3. If prompted, type the worksheet password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.), and then click OK.
  4. On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges.
  5. In the Ranges unlocked by a password when sheet is protected list, click the range for which you want to change the password.
  6. Click Modify, and then click Password.
  7. Type the new password for the range in the New password box.
  8. Type the same password in the Confirm new password box, and then click OK twice.
  9. Click Protect Sheet.
  10. Type the worksheet password in the Password to unprotect sheet box.
  11. Click OK, and then retype the worksheet password to confirm it.

 Important   Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.

ShowChange which users can edit which cells

  1. Open the workbook and switch to the protected worksheet.
  2. On the Tools menu, point to Protection, and then click Unprotect Sheet.
  3. If prompted type the worksheet password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.), and then click OK.
  4. On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges.
  5. Do one or more of the following:

ShowChange which users are allowed to edit a range

  1. In the Ranges unlocked by a password when sheet is protected box, click the range for which you want to change the users.
  2. Click Modify, and then click Permissions.
  3. Do one or more of the following:
    • To block a user temporarily from editing the range, click the user in the Name list, and then select the Deny check box for the user.
    • To unblock a user, click the user in the Name list, and then select the Allow check box for the user.
    • To remove a user permanently, click the user in the Name list, and then click Remove.
    • To add a new user, click Add, locate and select the new user, click Add, and then click OK.
  4. Click OK, click Yes if prompted about denying users, and then click OK again.

ShowChange which cells are included in a range

  1. In the Ranges unlocked by a password when sheet is protected box, click the range for which you want to change the included cells.
  2. Click Modify.
  3. In the Refers to cells box, type or select the new range, and then click OK.

ShowRemove protection for a range

  1. In the Ranges unlocked by a password when sheet is protected box, click the range you want to delete.
  2. Click Delete.
  1. When you are finished making changes in the Allow Users to Edit Ranges dialog box, click OK.
  2. On the Tools menu, point to Protection, and then click Protect Sheet.
  3. Type the worksheet password in the Password to unprotect sheet box.
  4. Click OK, and then retype the worksheet password to confirm it.

ShowChange the protection or password for a workbook

  1. Open the protected workbook.
  2. On the Tools menu, point to Protection, and then click Unprotect Workbook.
  3. If prompted type the current password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.), and then click OK.
  4. On the Tools menu, point to Protection, and then click Protect Workbook.
  5. If you want to change the protection, select the Structure or Windows check box, or both check boxes.
  6. Do one of the following:
    • To keep the same password, type it in the Password box.
    • To change the password, type a new password instead.
  7. Click OK. If prompted, retype the password to confirm it.

 Note   It is very important that you remember the password that you set. Without the password, there is no way to unprotect the workbook or worksheet.

 Important   Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.

Remove protection

ShowRemove protection from a worksheet

ShowRemove user permissions for a range

  1. Switch to the protected worksheet.
  2. On the Tools menu, point to Protection, and then click Unprotect Sheet.
  3. If prompted, enter the protection password (password: A way to restrict access to a workbook, worksheet, or part of a worksheet. Excel passwords can be up to 255 letters, numbers, spaces, and symbols. You must type uppercase and lowercase letters correctly when you set and enter passwords.) for the worksheet.
  4. On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges.
  5. In the Ranges unlocked by a password when cell is protected list, click the range for which you want to remove permissions.
  6. Click Delete.

ShowRemove protection from a workbook

ShowRemove protection from a shared workbook

 
 
Applies to:
Excel 2003