Data Validation

[danpre]

Hi Team,

I have prepared data validation in excel.

It allows me to enter the data only the field which i have given in dropdown list - Its working fine.

But if i copy the data from somewhere else and paste the data into that data validation cell then Data validation doesn't work and it overwrite the data.

Could you please let me know what to do so that user cannot the copy data from somewhere and paste it - He should only able to enter the data only which i have specified in the dropdown list.

Thanks for your help in advance

 

[ogo]

Check this: http://www.mrexcel.com/forum/showthread.php?t=84495

 

[danpre]

Thanku ver much