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