Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Password Protection - paste to unprotected cell locks the cell | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Protection using the subtotal function | Excel Worksheet Functions | |||
Protection function is not available | Excel Discussion (Misc queries) | |||
cell protection | Excel Discussion (Misc queries) |