Hello,
I have a simple drop-down menu that hides a cell that commands the choice of the cell itself.
The entered data is subsequently copied into a database through a macro.
My problem is that if the user gets it wrong and selects the cell instead of the menu he can easily delete the formula.
How can I prevent this from happening and at the same time make the drop-down menu work?
I have a simple drop-down menu that hides a cell that commands the choice of the cell itself.
The entered data is subsequently copied into a database through a macro.
My problem is that if the user gets it wrong and selects the cell instead of the menu he can easily delete the formula.
How can I prevent this from happening and at the same time make the drop-down menu work?
01.GESTIONE_CQ.xlsm | ||||
---|---|---|---|---|
B | C | |||
6 | EXAMPLE | ANSWER 2 | ||
FORM_ACCERTAMENTO |
Cell Formulas | ||
---|---|---|
Range | Formula | |
C6 | C6 | =INDEX(List!A2:A5,List!B1) |