Protect Workbook

 

Structure | Windows

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

Structure

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

1. Open a workbook.

2. On the Review tab, click Protect Workbook.

Click Protect Workbook

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

Protect workbook for Structure

4. Reenter the password and click on OK.

Confirm Password

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

Worksheet Commands are Grayed out

Windows

If you protect the workbook windows, users cannot move, change the size and close windows anymore.

1. Open a workbook.

2. On the Review tab, click Protect Workbook.

Click Protect Workbook

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

Protect workbook for Windows

4. Reenter the password and click on OK.

Confirm Password

Users cannot move, change the size and close windows anymore.

No Minimize, Maximize, Close Buttons

To unprotect the workbook, click Protect Workbook and enter the password. The password for the downloadable Excel file is "easy". The structure and window of this workbook are protected.