Microsoft Office Tutorials and References
In Depth Information
Protecting a Whole Workbook
Entering a password prevents you—or anyone else—from unprotecting the sheet. Once you type a
password—which is optional—another dialog box appears (Figure 7–22):
Figure 7–22. The password confirmation prompt. Protect the password, too.
Note the caution. Once you click OK, the password is duly recorded. Try now to unprotect the sheet,
a n d y ou’ l l be pr ompte d for the pa sswor d. Hope y ou wr ote i t down .
Protecting a Whole Workbook
You can also protect an entire workbook—but doing so brings about a result you’re not likely to expect.
Pr otecting a workbook does not seal off every cell in the entire book from data entry. On the contrary;
if you protect a workbook, all its cells can continue to receive data. Rather, workbook protection
prevents the user from making what Excel calls structural changes in the book—that is, adding moving,
renaming, or deleting worksheets. It will also allow you to protect against changes to current window
sizes, meaning if you accept this option and your worksheet currently occupies less than a whole
screen’s worth of space, you won’t be able to restore it to full size via the Maximize button, for example.
But that’s a less relevant option for most users.
To protect a workbook, click the Review tab Protect Workbook button in the Changes button
group. You’ll see (Figure 7–23):
 
Search JabSto ::




Custom Search