Microsoft Office Tutorials and References
In Depth Information
Protecting workbooks and worksheets
In the Reenter password to proceed box, enter prot300pswd , and then click OK .
Click the Weights sheet tab to display the Weights worksheet.
Select the cell range B2:C7 .
On the Review tab, in the Changes group, click Allow Users to Edit Ranges to open
the Allow Users to Edit Ranges dialog box.
Click New . When you do, the New Range dialog box opens, with the range B2:C7
displayed in the Refers to cells box.
In the Title box, enter AllWeights .
In the Range password box, enter work14pro , and then click OK .
In the Confirm Password dialog box, reenter the password work14pro . The range
appears in the Allow Users to Edit Ranges box.
Click Protect Sheet to open the Protect Sheet dialog box.
In the Password to unprotect sheet box, enter work14pro , and then click OK .
In the Confirm Password dialog box, reenter the password work14pro , and then
click OK .
CLEAN UP Close the SecureInfo workbook, saving your changes if you want to.