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

448 Protecting the Spreadsheet
Figure 1-6:
Setting the permissions for each user in the Permissions dialog box.
11. Repeat Step 10 for each user who must know the password and then click OK in the Permissions dialog box.
As soon as you click OK, Excel displays a warning alert dialog box, let- ting you know that you are setting a deny permission that takes prece- dence over any allowed entries, so that if the person is a member of two groups, one with an Allow entry and the other with a Deny entry, the deny entry permission rules (meaning that the person has to know the range password).
12. Click the Yes button in the Security alert dialog box.
Doing this closes this dialog box and returns you to the New Range
dialog box.
13. Click OK in the New Range dialog box.
Doing this opens the Confirm Password dialog box where you must
accurately reproduce the range password.
14. Type the range password in the Reenter Password to Proceed text box and then click the OK button.
Doing this returns you to the Allow Users to Edit Ranges dialog box where the title and cell reference of the new range are displayed in the Ranges Unlocked by a Password When Sheet Is Protected list box, as shown in Figure 1-7.