sodcalculator

10 Tech How-To

Protect Workbook Structure & Windows in Excel

Guide 10-46398 · Updated · Step by step

This guide shows you how to lock the structure of an Excel workbook so users cannot add, delete, rename, move, or hide sheets, and how to keep windows from being resized or moved. You’ll also learn how to set a password to prevent others from removing the protection. This is useful when sharing a workbook for data entry or reporting and you need to keep the layout intact.

What You’ll Need

  • Microsoft Excel (2010 or later; steps are similar across versions).
  • A workbook you want to protect (the file can be .xlsx or .xlsm).
  • Optional: a password you want to use for unprotecting. If you forget it, you cannot remove the protection.

Step-by-Step

  1. Open your workbook in Excel.
  2. Go to the Review tab on the ribbon.
  3. In the Protect group, click Protect Workbook (not Protect Sheet). A dialog box appears.
  4. In the dialog, check the box for Structure. This prevents users from adding, deleting, renaming, moving, hiding, or unhiding sheets.
  5. Optionally, check Windows to lock the size and position of the workbook window. Note: this only works in Excel for Windows; on Mac, this option is not available.
  6. If you want to require a password to unprotect, type a password in the Password (optional) box. This is case-sensitive.
  7. Click OK. If you set a password, Excel will ask you to re-enter it. Do so and click OK.
  8. Save the workbook (Ctrl+S or Cmd+S). The protection is now active.
  9. To test it, try to right-click a sheet tab and select Insert or Delete – those options will be greyed out.

Common Mistakes

  • Confusing Protect Workbook with Protect Sheet. Protect Sheet locks cells and formatting, not the sheet structure. You need Protect Workbook for structure.
  • Forgetting to check the Windows box. If you want to lock window size, you must check it. Many users only check Structure and wonder why windows can still be resized.
  • Not saving after protecting. If you close without saving, protection is lost.
  • Using a weak password. Excel’s protection is not encryption; it can be removed by advanced users. Use a strong password if you need moderate security.
  • Protecting the workbook but leaving the sheet unprotected. Structure protection does not prevent users from editing cell values. If you need to lock cells, you must also protect the sheet.

Tips

  • To unprotect later, go to Review > Protect Workbook again, and click Unprotect Workbook. If you set a password, you’ll be prompted for it.
  • You can protect the workbook structure and still allow users to edit data, as long as the sheets themselves are not protected.
  • If you want to prevent users from hiding sheets, structure protection does that. But note that they can still unhide sheets if they know the names – structure protection prevents the action, but not viewing hidden sheets.
  • Consider using a password that is easy to remember but not obvious. Write it down somewhere safe.
  • If you’re sharing the workbook via OneDrive or SharePoint, you can also set permissions there, but that’s separate from Excel’s built-in protection.

Troubleshooting

I can’t find the Protect Workbook button. Make sure you’re on the Review tab. If you’re using Excel for Mac, the option is under Review > Protect Workbook, but the Windows checkbox may not be available. If you’re using Excel Online, the feature is not available – you’ll need the desktop app.

I checked Windows but it doesn’t seem to do anything. The Windows protection only prevents users from moving, resizing, or closing the workbook window. It does not lock the ribbon or the workbook area. Also, it only works in Excel for Windows, not on Mac or web.

I forgot the password. Unfortunately, there is no official way to recover a lost password for workbook structure protection. You can try using a third-party tool, but that’s not recommended for security reasons. Always keep a backup of the unprotected file.

I can still add a sheet after protecting. That means the protection was not applied correctly. Go to Review > Protect Workbook and make sure the Structure checkbox is checked. Also, check that you clicked OK and saved the file.

Users can still edit cells. That’s expected – structure protection doesn’t lock cells. To lock cells, you need to protect each sheet (Review > Protect Sheet) and set the allowed actions.

The Protect Workbook option is greyed out. This can happen if the workbook is shared (legacy shared workbook). You’ll need to turn off sharing first: Review > Share Workbook, uncheck the box, and click OK.

Frequently Asked Questions

Does protecting the workbook structure prevent users from editing data?

No. It only prevents changes to the sheet structure (add, delete, rename, move, hide). To lock cell contents, you must also protect the individual sheets.

Can I protect the workbook structure without a password?

Yes. Just leave the password box empty. Anyone can unprotect it by clicking Protect Workbook and then Unprotect Workbook, but it still prevents accidental changes.

Does the Windows protection work on Excel for Mac?

No. The Windows checkbox is only available in Excel for Windows. On Mac, you can protect the structure but not the window.

Can I still add a new sheet if the structure is protected?

No. Adding a sheet is a structural change, so it’s blocked. You’ll see the Insert option greyed out.

Is this protection secure?

It’s not strong encryption. It’s meant to prevent accidental changes. A determined user can remove it with third-party tools. For sensitive data, use file-level encryption (File > Info > Protect Workbook > Encrypt with Password).

How do I unprotect the workbook later?

Go to Review > Protect Workbook, and click Unprotect Workbook. If you set a password, you’ll be asked for it. After unprotecting, you can make changes to the structure.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →