Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Sharing Your Work with the Outside World
Removing worksheet protection
Just follow these steps to remove any worksheet protection you may have applied:
1. Click the Unprotect Sheet icon on the Review tab.
2. If you specified a password while protecting the worksheet, Excel asks you for that password
(see Figure 19-9). Type the password and click OK to immediately remove protection.
Figure 19-9: The Unprotect Sheet icon removes worksheet protection.
Protecting the workbook structure
If you look under the Review tab in the Ribbon, you see the Protect Workbook icon next to the
Protect Sheet icon. Protecting the workbook enables you to prevent users from taking any action
that affects the structure of your workbook, such as adding/deleting worksheets, hiding/unhiding
worksheets, and naming or moving worksheets. Just follow these steps to protect a workbook:
1. To open the Protect Structure and Windows dialog box, click the Protect Workbook icon on
the Review tab of the Ribbon, as shown in Figure 19-10.
2. Choose which elements you want to protect: workbook structure, windows, or both. When a
check box is cleared for a particular action, Excel prevents users from taking that action.
3. If you provided a password, reenter the password.
4. Click OK to apply the worksheet protection.
Figure 19-10: The Protect Structure and Windows dialog box.
Selecting Structure prevents users from doing the following:
➤ Viewing worksheets that you’ve hidden
➤ Moving, deleting, hiding, or changing the names of worksheets