Blue Flower

How to Lock the Entire Workbook in Excel

In the previous tutorial we learned how to protect cells and worksheet in Excel. In this tutorial we continue with the topic of teaching beginners to protect a workbook in Excel 2013.

The actions described in this topic, we do protect the entire Workbook in Excel. The first part of the tutorial refers to lock and protect structures and windows open workbook.

The Structure of the Workbook in Excel

What is the Structure of the Workbook in Excel?

Under the structure of the workbook mean all worksheets to a workbook contains, as well as their arrangement or the order. When you lock the structure, the user does not have the ability to add, delete, hide, edit or create a new worksheet as well as the relocation of the order of Worksheets. You are not active, some commands on the shortcut menu, which you can see in the picture at the end of this tutorial.

Protecting the structure of the Workbook in Excel

Command to start the protection structure of the workbook in Excel starts the Review toolbar. You need to click on the command Protect Workbook. Also you notice Protect and Share Workbook command.

protect structure commands for workbook in excel

Protection Structures Excel Workbook can also run through File-Info menu. Click on the command Protect Workbook and then click on the list of commands on the Protect Workbook Structure command.

 protect structure workbook in excel 2013

After starting the dialog window to Protect the Structure of the Workbook note that Excel 2013 in this case there is only one option that is available (Structure). Password is not required but if you really want to protect the structure then set a password, and do not forget.

protect structure and windows in excel 2013 

After locking or protecting structures workbook, right-click mouse on the name of a worksheet. Note that the shortcut menu, you do not have an active some of the commands, because the structure is locked. 

protected structure of workbook in excel 2013 

Protecting Excel Workbook from opening, changing data, or permit the use of read-only

In as much as have a need to lock or protect a workbook from opening or modifying data or read-only protection then this can be done through File-Info text menu. Clicking the Save As command, you will open a dialog window where you notice the Tools command drop-down list that contains several commands and we are interested in the General Options command.

Clicking on the General Options command opens a dialog box in which we can include some of the options.

  • Always create backup (Option for permanent archiving Excel Files)
  • Password to open (Password to permit opening an Excel Workbook)
  • Password to modify (Password for permission to change data in an Excel workbook)
  • Read-only recomended (no possibilities for data exchange)

 protect excel workbook for open change or read only

For each password you typed, you will need to confirm the new dialog box.