$$Excel-Macros$$ not allow user to paste any thing in data validation column

hi need any macro that will not allow user to paste any thing in data validation column for example i have put validation on col a anyone can copy data from any cell and paste in any cell of col a .. how can it be stopped or not allowed . regards ashish -- --

$$Excel-Macros$$ not allow user to paste any thing in data validation column

hi need any macro that will not allow user to paste any thing in data validation column for example i have put validation on col a anyone can copy data from any cell and paste in any cell of col a .. how can it be stopped or not allowed . regards ashish -- --