To protect a sheet
-
Right-click on the sheet that you want to protect and select Protect
Sheet.
- Set the permissions by selecting appropriate check boxes.
- Enter the password in Password to unprotect sheet text-box.
-
Click OK.
Note:
You will receive a validation message when you provide a wrong password in App Settings in order to protect the sheet. The name of the sheet is also provided with the validation message.