Unprotect Excel Workbook

Unprotect Workbook in Excel

Once the report is finalized we will share the workbook with concerned team or personnel. Often times we just need them to read the report without doing any modification to the existing report. So, in order to prevent readers from tampering the data, we should allow them to alter anything in the workbook. There are two ways of protecting the workbook in excel and in our earlier article “Protect Workbook” we have seen how to protect the workbook in those two ways. Below are the steps to protect and unprotect workbook in excel in brief.

Excel Workbook Protection at File Level

In this method, we are protecting the entire workbook from opening and editing the content of the workbook.

The option of Protect Workbook is a built-in tool in excel. This is available under the REVIEW tab in excel.

To protect the workbook below are the steps.

Step 1: First we need to open the excel workbook that we need to protect.

Step 2: Then go to the REVIEW tab and click on PROTECT WORKBOOK option.

Step 3: Now we can see below option which asks for a password to be entered to protect. In the below Protect Structure and Windows window enter the password as per our choice.

Step 4: Click on OK, in the next window we need to re-enter the same password as we have entered in the previous step.

Click on Ok, it will protect the workbook at the file level.

Excel Workbook Protection at Workbook Level

We have seen how to protect workbook at the file level in the previous step. In this method, we can protect the workbook at workbook level which will prevent a user from opening it when you are not around with your computer.

Popular Course in this category

All in One Excel VBA Bundle (35 Courses with Projects)4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion

View Course

Using this method we restrict the user from peeping into the workbook. Follow the below steps to protect the workbook at the workbook level.

Step 1: Go to File option which is the first one in the ribbon.

Once we click on FILE option we will see Protect Workbook option on the right-hand side as shown in the below image.

Step 2: In the Protect Workbook option click on the drop-down list to see the options of “Protect Workbook”, in the list select “Encrypt with Password”.

Step 3: Now we will see the “Encrypt Document” window, in this enter the password as per our wish and click on OK button.

Step 4: Now in the next window we will see the window which asks us to re-enter the password as we entered in the previous step.

One thing is we need to remember the password that we have entered.

Once you have re-entered the password save and close the workbook, all the changes that we made will apply to the workbook.

Next time when we need to open the workbook it will ask us to enter the password.

Once the workbook is protected with a password, to unprotect we need to remember the exact password that we have entered while protecting the workbook. Follow the below steps to unprotect the protected workbook in excel.

Step 1: Open the desired workbook.

Step 2: While opening it will ask you to enter the password.

Step 3: Enter the password that you had given while protecting it.

Step 4: Click on OK, it will open the workbook.

Step 5: To unprotect click on FILE, you will see “Protect Workbook” option.

As we can see just below the “Protect Workbook” option it says “A Password is required to open this workbook”.

Step 6: Click on the drop-down list, and choose “Encrypt with Password”.

Step 7: Now we will see below window.

We can see the password with black dots, so to unprotect the workbook, delete the password and click on OK.

Now the excel workbook is unprotected and no longer has it required the password to open it.

Things to Remember

Password is mandatory to open the workbook if it is protected with a password.
But for unprotecting the workbook password is not required we can just delete the password and unprotect the workbook.
Protect Workbook and Protect Worksheet both are different from each other.

Unprotect Workbook in Excel

Excel Workbook Protection at File Level

Excel Workbook Protection at Workbook Level

Unprotect Excel Workbook

Things to Remember

Recommended Articles