Workbook protection in Excel

Protection in excel means, disallowing the user to make changes to the workbook or in some cases, to open the workbook or worksheet.

This involves setting a password and the modifications,deletions can be done only if the password is known to the end user.

Many organizations official excel documents used by the employees are somehow protected either, a sheet,a cell or even the entire workbook.

The chapter explains how to protect a workbook.

To protect the workbook, Click Review menu and choose "Protect Workbook" as shown below.

excel workbook protection

The following window appears.

excel workbook protection

The 'Password' textbox is where the password is given.

Note that, the password is optional, which means that a workbook can be protected without a password but, anyone can unprotect it with a single click.

Once the password is given, it opts for confirmation and the workbook is protected.


You can find similar Excel Questions and Answer hereunder

1) Calling a macro from another workbook in Excel

2) How to do workbook protection with VBA in Excel

3) I want to automatically run a procedure whenever I close my WorkBook so that it is in a known state - how can I achieve that?

4) How can I save a WorkSheet as a new WorkBook using VBA?

5) How do I disable the right click option for users in my WorkBook?

6) I have a WorkBook that loads a form automatically when it is opened. In Excel, how can I suppress the form from loading on file open when required?

7) How do you close, save, open files and do other operations in the workbook in VBA

8) How can I quickly navigate to a frequently used field in a voluminous worbook?

9) Here we explain the thisWorkbook object and its functionalites

10) How to protect your worksheet from changes in Excel


Here the previous and next chapter