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