Prevent Clear Contents

[abduhsuryadi]

I have some cells that I must protect it from a blank. the user just can enter a specific data.
then i use data validation to do it.

the problem is, the user can clear the data or can paste data to the cell, so my validation lost.
how to prevent this action?

thanks

[CatDaddy]

http://www.pcreview.co.uk/forums/validation-list-not-allow-cell-empty-t3725922.html

[mikerickson]

Have you un-checked the IgnoreBlanks on the data validation?