Enabling workbook protection

<< Click to Display Table of Contents >>

Enabling workbook protection

To enable workbook protection for the current document, proceed as follows:

1.Choose the ribbon command Review | group Protection | Workbook protection workbook_protect_icon_a.
2.If desired, you can now enter a password that must be entered by the user to disable workbook protection.
If you do not want to assign a password, simply leave the input field blank.
3.Confirm with OK.

Workbook protection is now enabled; it is no longer possible to insert, delete, show/hide worksheets, etc.

Furthermore, most of the options in the dialog box of the command File | Properties are no longer available.