Run macro after paste?

[winxpdows]

Hi, All.

I'm building an add-in with data validation. But if a user copies and pastes over cells the data validation that was there is wiped out. Is there a way to catch if a user has pasted data into a sheet so that I can run a macro to reinstall the data validation? I don't want to use Sheet change code because I want to prompt the user to ask them if they want to reinstall the data validation... I just can't figure out a way to handle if data has been pasted.

Thanks in advance!

 

[Jonmo1]

There is a workaround, it's kinda wiered and I'm not sure why it works...

But anyway...

Highlight the range of Data Validation
Click Tools - Protection - Allow users to edit ranges
Cick New - give it a name, make sure it references the right range.
Click OK
Click OK

Now protect the sheet from Tools - Protection - Protect Sheet


Now when pasting over, your data validation will be preserved..


If you were not already using sheet protection, you can basically make the protection invisible..

Highlight all cells, click Format - Cells - Protection
UNcheck Locked
Click Tools - Protection - Protect Sheet
put a check on ALL boxes
Then click OK without a password

so protection is ON, but it's not actually protecting anything.


Hope that helps, and was clear enough..

 

[winxpdows]

Thanks Jonmo...

That's a workaround, but... I'd still like to find a way to run a macro when the user pastes something... Appreciate your help, though.