I am trying to lock a data validation list so the user can ONLY select what is in the list and not remove the list. I know i can prevent text changes by enabling the Error Alert option but, if i am in that cell, i can still hit my DEL key and it will remove all data from that cell leaving it blank. How can i prevent that from happening?
Bookmarks