Hi,

I have a column where I have applied validation for dates but when
someone uses the paste option then
the validation is of no use.

I want a macro which will not allow the user to paste anything in a
particular column. The user has to enter the date without using the
copy paste option.

Basically i want to disable the paste option in a particular range.

Regards
Heera