Tutorial 6.4: Allowing Users to Edit Ranges

Author: Greg Hawes- greghawes@byu.net

Allowing users to edit ranges

You may want to give different users the permission to edit different parts of the worksheet. To do this, simply follow these steps.

1) Click on “Tools,” “Protection,” and “Allow users to edit ranges.”

2) Click on “New” in the dialog box.

3) Name the range in the “Title” box. Then, in the “Refers to cells” box, highlight the cells you want the given password to allow to edit. Give the range a password and select “OK.” You will be prompted to re enter the password in order to verify you entered it correctly.

4) Repeat steps 2 and 3 for all the ranges you want to specify for users to edit.

5) You must protect the worksheet for the passwords in the “Allow users to edit ranges” dialog box to become effective.

Now the given ranges are protected from unauthorized editing. Only those who know the password for the specific range can edit that range. To do so, they must enter the password for the range. A dialog box like the one shown below comes up when a user originally attempts to edit a protected range.

The user must enter the correct password in order to be able to edit that range of cells.

This is a very useful tool for sheets that need to have multiple people enter different data on it. This way, one person’s work will not be accidentally or intentionally altered by another person who uses the workbook for other reasons.

Source:http://office.microsoft.com/training/training.aspx?AssetID=RC011234971033.