| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation - Prevent delete
Hi guys,
I have user input on cell A1 and check cell on B1 After User enter his data on A1 and if the data is correct, manager fill CELL B1 to confirm the entry. After the manager fill CELL B1, we do not want any user to change A1, before deleting B1 first. What formula should I use in DATA VALIDATION to prevent deleting data on Cell A1, when B1 is not empty? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent Tab from User Delete | Excel Worksheet Functions | |||
| Prevent Insert Row and Delete Row from Menu | Excel Discussion (Misc queries) | |||
| How can I prevent the use of delete key in a cell | Excel Discussion (Misc queries) | |||
| Allow Edit Prevent Delete | Excel Worksheet Functions | |||
| Data validation to prevent duplicate entry. | Excel Discussion (Misc queries) | |||
Threaded Mode
