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

Protecting the Spreadsheet 445
protected worksheet, Excel displays an alert dialog box with the following message:
The cell or chart you’re trying to change is on a protected sheet.
The message then goes on to tell you
To make changes, click Unprotect Sheet in the Review tab (you might need a password).
If you’ve assigned a password to unprotect the sheet, when you click the Unprotect Sheet button, the program displays the Unprotect Sheet dialog box, where you must enter the password exactly as you assigned it. As soon as you remove the protection by entering the correct password in this dialog box and clicking OK, Excel turns off the protection in the sheet, and you can once again make any kinds of modifications to its structure and contents in both the locked and unlocked cells.
Keep in mind that when you protect a worksheet, only the data and graphics on that particular worksheet are protected. This means that you can modify the data and graphics on other sheets of the same workbook without remov- ing protection. If you have data or graphics on other sheets of the same workbook that also need protecting, you need to activate that sheet and then repeat the entire procedure for protecting it as well (including unlock- ing cells that need to be edited and selecting which other actions, if any, to enable in the worksheet, and whether to assign a password to unprotect
the sheet) before distributing the workbook. When assigning passwords to unprotect the various sheets of the workbook, you may want to stick with a single password rather than have to worry about remembering a different password for each sheet, which is a bit much, don’t you think?
Enabling cell range editing by certain users
You can use the Allow Users to Edit Ranges command button in the Changes group on the Review tab of the Ribbon to enable the editing of particular ranges in the protected worksheet by certain users. When you use this feature, you give certain users permission to edit particular cell ranges, provided that they can correctly provide the password you assign to that range.
To give access to particular ranges in a protected worksheet, you follow these steps:
1. Click the Allow Users to Edit Ranges command button on the Ribbon’s Review tab or press Alt+RU.
Book IV Chapter 1
Protecting Workbooks and Worksheet Data