How to unprotect protected sheets?

Posted on

In this article, I will demonstrate how to unprotect protected sheets in Excel workbooks. 

In the templates you will find on indzara.com, some sheets are protected and will not allow you to make certain changes. Let me explain why I protect certain sheets.

I build each template with the goal of keeping it very simple and easy for the user to use it and get the task done quickly. In order to achieve that, I write several formulas in one or multiple sheets in the workbook. The functioning of the template depends on these calculations. If by mistake these formulas are modified, the template will not provide the intended result. So, keeping the formulas intact is critical. Excel allows protecting  individual sheets and prevent certain types of changes by the user unless a password is entered. This is a great feature (more from Microsoft Excel Help) and I use it in almost all my templates. This allows me to build very sophisticated calculations behind the scenes and the user does not have to worry about making any modifications to the formulas unintentionally.

For the default functionality, you do not have to unprotect sheets at all. I design the template such that the user can use the template as it is delivered. In certain scenarios, the user is an Excel savvy person, completely understands the formula used and is aware of exact impacts if the formula is modified. If he/she would like to make modifications to the template to suit their unique needs, I encourage it. Hence, I provide the password for each template. (All free templates use the same password indzara) You do not have to use it, but if you want to, you can. When you want to expand the template’s functionality, you can unprotect the sheet using the password, make changes as needed and then protect the sheet again. I highly recommend protecting the sheet again to prevent unintentional editing of formulas.

 

The following are the steps to unprotect a sheet and protect it again.

 

UNPROTECTING

  • Go to the REVIEW ribbon and click on ‘Unprotect Sheet’ button in the ‘Changes’ area.
    Unprotecting Sheets - Excel Templates - Unprotect Sheet
    Unprotecting Sheets – Excel Templates – Unprotect Sheet

     

  • Enter Password to unprotect sheet. If you do not know the password, please e-mail.

    Unprotecting Sheets - Excel Templates - Enter Password
    Unprotecting Sheets – Excel Templates – Enter Password
  • You can now make any changes you need to make.

 

PROTECTING SHEET AGAIN

 

Go back to the REVIEW ribbon and now click on ‘Protect Sheet’ button.

Protecting Sheets - Excel Templates
Protecting Sheets – Excel Templates

 

Enter the password you would like to use. You can use the same password as before or if you would like to create your own new password, you can do that too. Please make sure to remember the password.

Protecting Sheets - Excel Templates - Enter Password
Protecting Sheets – Excel Templates – Enter Password

 

Leave the checked items as they appear. Items that are checked (or selected) might change from template to template, but you can just click OK as Excel will remember the original selected items (when you received the template).

After clicking OK, Excel will show another dialog box asking you to re-enter password. Please do and click OK.

Protecting Sheets - Excel Templates - Confirm Password
Protecting Sheets – Excel Templates – Confirm Password

Now you have protected the sheet. If any one tries to make certain types of modifications, Excel will ask for a password.

 

If you have any questions about this article, please leave them in the comments below.


Permanent Link: https://indzara.com/faq-items/unprotectingprotectedsheets/