Cell with data validation allows blanks, pastes, deletions - How do I protect?

F

fuzzyfreak

Thanks mzehr, this appears to stop anything other than what you specif
being entered, even though for it to work I have to add everything i
my list into the macro. But how do I stop a deletion or a blan
entry?

Fuzz
 
M

mzehr

Fuzzy,
For that you will probably want to consider forcing the
user to input the information into a user for. For
starters see:

http://www.exceltip.com/st/Create_User_Forms_in_Microsoft_E
xcel/629.html
you would then need to modify the code to prevent leaving
blanks, etc.

I will have to defer to my other colleagues out here who
are more adept at VBA than I to point you further.
HTH
 
Top