To apply group-level protection to a worksheet, follow these steps:
1.Start Excel, and then open a blank worksheet.
2.On the Tools menu, point to Protection, and then click Allow Users to Edit Ranges.
Note If you are running Excel 2007, click Allow Users to Edit Ranges in the Changes group on the Review menu.
3.In the Allow Users to Edit Ranges dialog box, click New.
4.In the New Range dialog box, click Collapse Dialog, select the range B2:B6, and then click Collapse Dialog again.
5.In the Range password box, type rangeone, and then click OK twice. When prompted, retype the password.
6.Repeat steps 3 through 5, selecting the range D2:D6 and typing rangetwo as the password for that range.
7.In the Allow Users to Edit Ranges dialog box, click Permissions, and then click Add in the Permissions for Range2 dialog box.
8.In the Select Users, Computers, or Groups dialog box, type Everyone.
9.Click OK in the Select Users, Computers, or Groups dialog box, and then click OK in the Permissions for Range2 dialog box.
10.In the Allow Users to Edit Ranges dialog box, click Protect sheet, type ranger in the Password to unprotect sheet box, and then click OK twice. When prompted, retype the password.
11.Select cell B3, and then start to type Dataone. A password is still required. Click Cancel in the Unlock Range dialog box.
12.Select cell D3, and then type Datatwo.
When you apply different passwords to separate ranges in this way, a range that has been unlocked remains unlocked until the workbook is closed. When you unlock another range, you do not relock the first range. Likewise, when you save a worksheet, you do not relock a range.
You can use existing range names to identify cells that are to be protected with passwords, but if you do, Excel converts any relative references in the existing name definitions to absolute references. Because this may not give you the results you intended, it is preferable to use the Collapse Dialog button to select the cells, as described earlier in this article.
No comments:
Post a Comment