Hi,

I have data validation in a column in my excel sheet. But when ever i copy data from another cell to any cell having data validation it allows to overwrite that data. I dont want to use any VBA macro to disallow this paste over validation.

Kindly suggest any other option for the same. So that only option in drop down can be selected and no any other copied data. Please remeber i dont want to use any macro.

Thnaks