Prevent Paste over Custom Data validation

[aravindhan_31]

Hi,

Can you guyes help me for protecting cells where the Custom Data Validation are used.

I got many answers protecting from paste for usual data validations but not for custom data validation.

thanks for your help

[dominicb]

Good morning aravindhan_31

Thiis is a problem that many users encounter and complain about.
There is nothing standard within Excel to combat this, but I have seen an ingenius solution to the problem proposed by MVp John Walkenbach here, along with an explanation of how it works.

HTH

DominicB