Prevent user from deleting the value in a given cell

Hi,
I have a column with dates. I NEED that column to have data. By default, the column will always have a predetermined value.

I need to allow the user to change the values, but do NOT delete the value (Cell must NEVER be empty).

How can I do that?

Thank you very much for the help.

You can use a Change Event and ensure entry is valid

Please Login or Register  to view this content.

to insert the abvoe right click on tab of interest - select View Code and paste above into resulting window

(modify ranges and logic to suit)