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

  • Thread starter Thread starter fuzzyfreak
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell with data validation allows blanks, pastes, deletions - How do I protect? 1
Indirect validation list with blank in list 3
Data Validation/Cell Protection Question 2
Protect Data validation cells from copy paste 3
Data Validation 1
Data Validation - Prevent delete 2
Protect validation but allow drop down selection 1
Data validation on data validation function 1

Back
Top