Microsoft Office Tutorials and References
In Depth Information
11. On the Review tab, in the Changes group, click Protect Sheet .
The Protect Sheet dialog box opens.
12. In the Password to unprotect sheet box, type prot300pswd .
13. Clear the Select locked cells and Select unlocked cells check boxes, and then
click OK .
The Confirm Password dialog box opens.
14. In the Reenter password to proceed box, type prot300pswd , and then click OK .
15. Click the Weights sheet tab.
The Weights worksheet opens.
16. Select the cell range B2:C7 .
17. On the Review tab, in the Changes group, click Allow Users to Edit Ranges .
The Allow Users To Edit Ranges dialog box opens.
18. Click New .
The New Range dialog box opens, with the range B2:C7 displayed in the Refers To
Cells box.
19. In the Title box, type AllWeights .
20. In the Range password box, type work14pro , and then click OK .
21. In the Confirm Password dialog box, reenter the password work14pro .
The range appears in the Allow Users To Edit Ranges box.
22. Click Protect Sheet .
The Protect Sheet dialog box opens.
23. In the Password to unprotect sheet box, type work14pro , and then click OK .
24. In the Confirm Password dialog box, reenter the password work14pro , and then
click OK .
CLEAN UP Save the SecureInfo workbook, and then close it.
Search JabSto ::




Custom Search