Hi, this may seem strange but I want to be able to determine within the
Worksheet_change code what the value of a cell was if someone hit the delete
key to erase it. What I have done is setup different "modes" via macros that
set a defined name to a yes or no. If not in a certain mode, I don't want the
user to erase some fields. I know I could keep a hidden column with a shadow
copy that I pickup and restore the other from. In fact, I do have some of
that already but there is so much interaction be sheets and code, adding
additional columns almost drives one to drink as there is always somewhere
you forget.

Another option would be to set some sort of protect on fields from the
enabling/disabling macro that if someone does try a delete, my code would get
control and be able to inform the user of the error of their ways. I am
trying not to use the Excel locked cell scheme as most of the time the
protection will be off. This is just to try to keep users from shooting
themselves in the foot.
--
Randy