Enabling workbook protection

<< Click to Display Table of Contents >>

Enabling workbook protection

To enable workbook protection for the current document:

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

Workbook protection is now enabled. Users are no longer able to add, delete, rename or hide/unhide worksheets, etc.

In addition, most of the options in the dialog box of the command File | Properties are unavailable.