Protect workbook elements
by Prabakaran[ Edit ] 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.
