How to Protect and Unprotect Workbook in Excel

This example teaches you how to protect the workbook structure in Excel.

If you protect the workbook structure, users cannot insert, delete, rename, move, copy, hide or unhide worksheets anymore.

Worked Example:   List sheet names with formula in Excel

1. Open a workbook.

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


3. Check Structure, enter a password and click OK.

Worked Example:   Create dynamic workbook reference to another workbook in Excel

Note: The Windows option is not available in Excel 2013 and later versions.

4. Reenter the password and click on OK.

Users cannot insert, delete, rename, move, copy, hide or unhide worksheets anymore.

Worked Example:   View Multiple Workbooks at The Same Time in Excel


Note: to unprotect the workbook, click Protect Workbook and enter the password. The password is “test”.

Leave a Reply

Your email address will not be published. Required fields are marked *