• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL

Chapter 17. Sharing Workbooks > Protecting Workbooks

Protecting Workbooks

You can protect selected aspects of workbooks or worksheets from changes, which may be useful in a sharing environment.

To protect a worksheet:

Choose Tools > Protection > Protect Sheet (Figure 17.12).

Figure 17.12. Choose Tools > Protection > Protect Sheet.

In the Protect Sheet dialog box (Figure 17.13), you can choose to protect the contents and other elements of cells. If there are cells you want users to be able to change, select those cells, choose Format > Cells (Figure 17.14), in the Format Cells dialog box click the Protection tab (Figure 17.15), and remove the checkmark from the Locked box.

Figure 17.13. Choose what you want to protect.

Figure 17.14. Choose Format > Cells.

Figure 17.15. Unlock cells you want others to be able to edit.

In the Protect Sheet dialog box, checking the box next to Objects protects such things as charts, graphics, and buttons from change or deletion.

If you choose to protect Scenarios, then any scenarios not hidden are protected from change.

In the Protect Sheet dialog box you have the opportunity to enter a password, and after clicking OK you are asked to confirm it (Figure 17.16).

Figure 17.16. Confirm your password.

To unprotect a sheet after it's been protected, choose Tools > Protection > Unprotect Sheet (Figure 17.17). You'll be prompted for the password (Figure 17.18).

Figure 17.17. Choose Tools > Protection > Unprotect Sheet.

Figure 17.18. Enter your password to unprotect the sheet.



Not a subscriber?

Start A Free Trial

  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint