Microsoft Office Tutorials and References
In Depth Information
Protecting a Workbook
Click Hidden, and then click OK. Then protect the worksheet, and click in
cell D9 and observe the formula bar (see Figure 9–49).
Figure 9–49. Drawing a blank: The formula’s no longer visible
The formula is nowhere to be seen, even though it’s still safely stored in cell D9. To
restore the formula to view, just unprotect the sheet.
NOTE: If you want to render all the worksheet formulas invisible, you need to select all the cells
in the worksheet (via Ctrl+A or by clicking the Select All button) and select Format Cells. Click
Hidden on the Protection tab, and then protect the sheet.
Protecting a Workbook
You can also protect an entire workbook, which does something completely different
from protecting a worksheet.
When you protect a workbook, you protect what Excel calls its structure —and that
means that when workbook protection is turned on, you won’t be able to delete or move
a worksheet, or restore a hidden worksheet to view.
Another workbook protection option—a less central one—enables you to protect the
window arrangement of worksheets. If, for example, you resize a worksheet window and
you need to maintain precisely that worksheet size and position on the screen,
protecting the workbook for windows will hold the worksheet right there—and you’ll be
able neither to move nor resize it (see Figure 9–50).
Search JabSto ::

Custom Search