I would like to write some VB code to stop users deleting the contents of cells in excel. The cells need to be unprotected as users need to input values in them, however, they have formulas in which link to a database. If a user presses the delete button they will remove the formula.

I need to write some code which activates when the delete button is hit. I have written some code, however, can only get it to activate when a button is clicked.

Can anyone help?