Protect workbook elements

by Prabakaran 2012-09-05 12:34:49

Protect workbook elements

On the Review tab, in the Changes group, click Protect Workbook.

Excel Ribbon Image

Under Protect workbook for, do one or more of the following:
To protect the structure of a workbook, select the Structure check box.
To keep workbook windows in the same size and position every time the workbook is opened, select the Windows check box.

ShowMore information about the elements that you can select

To prevent other users from removing workbook protection, in the Password (optional) box, type a password, click OK, and then retype the password to confirm it.

Note The password is optional. If you do not supply a password, then any user can unprotect the workbook and change the protected elements. Make sure that you choose a password that you can remember, because if you lose the password, you cannot gain access to the protected elements in the workbook.

You must LOGIN to add comments