I have a workbook that must allow data entry by 3 people.
However, each person must only have access to enter/edit their specific data
range.
I need to password protect the 3 ranges with separate passwords for each.
Protecting the sheet is of no use as they would all have the same password.
I cannot separate the data on different sheets/workbooks.
They need to be able to "click" a button, enter their password then have
access to ONLY their data range.
Any help greatly appreciated.
cheers,
Nadia

cant you just give each of them their own workbook, with your "master book
reading the data from their pages

will give you all your answers on one page bur also stop them reading the
other 2s comments

"Nadia" wrote:

I have a workbook that must allow data entry by 3 people.
However, each person must only have access to enter/edit their specific data
range.
I need to password protect the 3 ranges with separate passwords for each.
Protecting the sheet is of no use as they would all have the same password.
I cannot separate the data on different sheets/workbooks.
They need to be able to "click" a button, enter their password then have
access to ONLY their data range.
Any help greatly appreciated.
cheers,
Nadia

In order to give specific users access to ranges, your computer must be on a
domain.

On the Tools menu, point to Protection, and then click Allow Users to Edit
Ranges.

Click New.

In the Title box, type a title for the range you're granting access to.

In the Refers to cells box, type an equal sign (=), and then type a
reference or select the range.

In the Range password box, type a password to access the range.

Click Permissions, and then click Add.

Locate and select the users to whom you want to grant access.

Repeat the previous steps for each range for which you're granting access.

Protect the worksheet: Click Protect Sheet in the Allow Users to Edit Ranges
dialog box.

In the Protect Sheet dialog box, make sure the Protect worksheet and
contents of locked cells check box is selected, type a password for the
worksheet, click OK, and then retype the password to confirm.

Thanks Rich, we were playing around with this and wouldnt work. The "other"
users are not on our domain so that would explain it.

cheers,
Nadia


"Rich" wrote:



In order to give specific users access to ranges, your computer must be on a
domain.

On the Tools menu, point to Protection, and then click Allow Users to Edit
Ranges.

Click New.

In the Title box, type a title for the range you're granting access to.

In the Refers to cells box, type an equal sign (=), and then type a
reference or select the range.

In the Range password box, type a password to access the range.

Click Permissions, and then click Add.

Locate and select the users to whom you want to grant access.

Repeat the previous steps for each range for which you're granting access.

Protect the worksheet: Click Protect Sheet in the Allow Users to Edit Ranges
dialog box.

In the Protect Sheet dialog box, make sure the Protect worksheet and
contents of locked cells check box is selected, type a password for the
worksheet, click OK, and then retype the password to confirm.