Disable paste option in worksheet.

[Heera]

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

 

[JE McGimpsey]

One way:

Unlock (Format/Cells/Protection) any cells that you want the user to be
able to type or paste into, then choose Tools/Protection/Protect
Worksheet.

A macro won't prevent a paste since no event will be fired until after
the paste is accomplished.

You *could* use an event macro (Worksheet_Change) to reapply validation
if it was removed by a paste, but you'll then have to deal with deciding
which value to insert (or use another event to store the value).