Page 470 - Excel 2013 All-in-One For Dummies

452 Protecting the Spreadsheet Protecting the workbook
There is one last level of protection that you can apply to your spreadsheet files, and that is protecting the entire workbook. When you protect the workbook, you ensure that its users can’t change the structure of the file
by adding, deleting, or even moving and renaming any of its worksheets. To protect your workbook, you click the Protect Workbook command button on the Ribbon’s Review tab and then select the Protect Structure and Windows option from its drop-down menu (or press Alt+RPW).
Excel displays a Protect Structure and Windows dialog box like the one shown in Figure 1-9. This dialog box contains two check boxes: Structure (which is automatically selected) and Windows (which is not selected). This dialog box also contains a Password (Optional) text box where you can enter a password that must be supplied before you can unprotect the workbook. Like every other password in Excel, the password to unprotect the work- book can be up to 255 characters maximum, consisting of a combination of letters, numbers, and spaces, with all the letters being case-sensitive.
Figure 1-9:
Protecting a workbook in the Protect Structure and Windows dialog box.
When you protect a workbook with the Structure check box selected, Excel prevents you or your users from doing any of the following tasks to the file:
✦ Inserting new worksheets
✦ Deleting existing worksheets
✦ Renaming worksheets
✦ Hiding or viewing hidden worksheets
✦ Moving or copying worksheets to another workbook
✦ Displaying the source data for a cell in a pivot table or displaying a table’s Report Filter fields on separate worksheets (see Book VII, Chapter 2, for details)
✦ Creating a summary report with the Scenario Manager (see Book VII, Chapter 1, for details)