Cell Function Protection
 

I have protected the sheet. Now I want users to be able to insert from the
drop down list. But once inserted, they should not be able to delete it.

Eg - my drop down list has the option only to select "YES".
Once the user selects YES and saves the file, nobody should be able to
delete it.

It is a shared workbook and 5 users would be using it at the same
time...which is why, I do not want any tampering with this data.

Senario - When clients walk in, if their names exists in the data base, the
user will select "yes" and move onto the next customer.

Cell Function Protection
 

Uncheck the 'Ignore blank' checkbox

--
__________________________________
HTH

Bob

"Fuzzy" wrote in message
...
I have protected the sheet. Now I want users to be able to insert from the
drop down list. But once inserted, they should not be able to delete it.

Eg - my drop down list has the option only to select "YES".
Once the user selects YES and saves the file, nobody should be able to
delete it.

It is a shared workbook and 5 users would be using it at the same
time...which is why, I do not want any tampering with this data.

Senario - When clients walk in, if their names exists in the data base,
the
user will select "yes" and move onto the next customer.