how to protect validated cells from copy-paste

[qbraz]

hi all

could you help me to clarify how to protect validated cells with predefined range of values from copy-paste?

[MSP77079]

You have found the big down side to data validation. It is easily destroyed by a user doing a copy/paste.

About the only thing I can suggest is a VBA procedure (macro), triggered by the Worksheet Change event, which checks to see if the validation is still intact, and if not, re-creates it.

[vikas.bhandari]

hi all

could you help me to clarify how to protect validated cells with predefined range of values from copy-paste?

Check this out :

http://excelforum.com/showthread.php?p=1622540

Hope this Helps