Workbook protection in Excel - Step-by-Step Guide

Introduction

Workbook protection helps you keep your Excel file structure safe. It stops others from adding, moving, or deleting sheets inside your workbook. This is useful when you want to share your file but keep its layout unchanged.

When you share a budget file and want to prevent others from deleting sheets by mistake

When you create a report with multiple tabs and want to keep the order fixed

When you prepare a template and want to stop users from adding new sheets

When you want to protect the workbook structure but still allow editing inside sheets

When you want to add a password so only certain people can change the workbook layout

Steps

Step 1: Click

- Review tab on the Ribbon

The Review tab options appear on the screen

Step 2: Click

- Protect Workbook button in the Changes group

The Protect Structure and Windows dialog box opens

Step 3: Check

- Structure checkbox in the dialog box

The workbook structure will be protected to prevent sheet changes

Step 4: Type

- Password field in the dialog box (optional)

A password is set to restrict who can unprotect the workbook

Step 5: Click

- OK button in the dialog box

Workbook protection is applied; a confirmation dialog appears if password was set

Step 6: Re-type

- Password confirmation box (if password was set)

Password is confirmed and protection is activated

Before vs After

Before

Workbook allows adding, deleting, renaming, and moving sheets freely

After

Workbook structure is locked; sheets cannot be added, deleted, renamed, or moved without unprotecting

Settings Reference

Structure

📍 Protect Workbook dialog box under Review tab

Prevents adding, deleting, renaming, or moving sheets

Default: Unchecked

Windows

📍 Protect Workbook dialog box under Review tab

Prevents moving, resizing, or closing workbook windows

Default: Unchecked

Password

📍 Protect Workbook dialog box under Review tab

Requires password to unprotect workbook structure

Default: Blank

Common Mistakes

Not setting a password when protecting the workbook

Anyone can easily unprotect the workbook and change the structure

Set a strong password to prevent unauthorized changes

Confusing workbook protection with worksheet protection

Workbook protection controls sheet structure, not cell editing inside sheets

Use worksheet protection separately to lock cells and content inside sheets

Forgetting the password after setting it

You cannot unprotect the workbook without the password, risking permanent lock

Store the password safely or avoid setting one if unsure

Summary

Workbook protection locks the structure to stop sheet changes like adding or deleting

You can add a password to control who can unprotect the workbook

Workbook protection does not stop editing inside sheets; use worksheet protection for that