Microsoft Office Tutorials and References
In Depth Information
Unprotecting a Worksheet
Unprotecting a Worksheet
Needless to say, once you’ve protected the worksheet, you may decide you need to
return the sheet to its original unprotected state so that it can receive data entries again.
All you have to do is go back to the Changes button group, where you’ll see that the
Protect Sheet button has toggled to display Unprotect Sheet (see Figure 9–43).
Figure 9–43. Flip side: The Unprotect Sheet button is the same one you clicked to protect the sheet
Just click Unprotect Sheet, and the sheet will be unprotected again—type away.
If you’ve used a password to protect a sheet and later decide to unprotect it clicking
Unprotect Sheet will call up an Unprotect Sheet dialog box prompting you to reenter your
password, as shown in Figure 9–44.
Figure 9–44. The Unprotect Sheet dialog box requests your password if you’ve selected one.
Just make sure you’ve written that password down somewhere, because if you forget it,
you won’t be able to unprotect the sheet. Remember as well that if you haven’t availed
yourself of the password possibility, anyone else can unprotect the worksheet—
provided of course they know how to do that.
Protecting Some, but Not All, of a Worksheet
In some cases, you may want to be able to enter data in some cells in a worksheet, even
as the remainder of the cells are blocked or protected. Recall our grading worksheet, in
which we calculated point bonus awards that supplemented students’ test scores see
Chapter 4 . In such a case, you might want to protect the cells containing the bonus
formulas while continuing to leave other cells available, in which you could enter
additional student test scores.
So how do you protect some but not all, of a worksheet? It’s here where some of those ,
workbook protection quirks mentioned earlier come into play.
Search JabSto ::

Custom Search