Protect Items in a Workbook

In Excel, protection means preventing changes to parts of a workbook. You can apply protection to worksheets, charts, ranges, formatting, and window layout. Protection can use a password, or it may omit the password if the protection is intended to prevent accidental changes rather than malicious ones.

You can protect multiple items within a workbook and you can use different passwords for each of those items, though that’s generally a bad idea. The more passwords you use, the more likely you are to confuse them—especially within a single workbook. It’s a good idea to use the same password when protecting multiple items.

Note

Protection allows users to read, but not change, parts of a workbook. Protection is applied in different ways to different items within a workbook.

How to do it

To prevent changes to a worksheet:

  1. Add data to your worksheet and adjust the formatting so it appears the way you want it to.

  2. From the Tools menu, choose Protection then Protect a Sheet. Excel displays the Protect Sheet dialog box shown in Figure 6-8.

  3. Type a password and select the actions you want to permit on the worksheet from the list. Click OK. Excel prompts you to confirm the password.

After a worksheet is protected, you can’t change it without unprotecting it first. To unprotect the worksheet, select Tools Protection Unprotect Sheet and enter the password.

Worksheet protection applies to all of the locked cells on a worksheet. To allow users to edit ...

Get Excel 2003 Programming: A Developer's Notebook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.