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) |
