Monday, 25 August 2014

How to Protect worksheet elements from all users in Excel?

  1. Switch to the worksheet you want to protect.
  2. Unlock any cells you want users to be able to change: select each cell or range, click Cells on the Format menu, click the Protection tab, and then clear the Locked check box.
  3. Hide any formulas that you don't want to be visible: select the cells with the formulas, click Cells on the Format menu, click the Protection tab, and then select the Hidden check box.
  4. Unlock any graphic objects you want users to be able to change.
    How?
  5. On the Tools menu, point to Protection, and then click Protect Sheet.
  6. Type a password for the sheet.
    Note  The password is optional; however, if you don't supply a password, any user will be able to unprotect the sheet and change the protected elements. Make sure you choose a password you can remember, because if you lose the password, you cannot gain access to the protected elements on the worksheet.
  7. In the Allow all users of this worksheet to list, select the elements that you want users to be able to change.
  8. Click OK, and if prompted retype the password.

No comments:

Post a Comment