Undo paste - code causes excel to crush/close

[lynnsong986]

Hello,

I have the worksheet_change event in each sheet - the one for Sheet1 works fine but the one for Sheet36 causes excel to crush (this is one of the tabs from a large financial model). I'm trying to undo any paste so that a user can't overwrite the data validation. Can someone please take a look why it happens?

thanks so much!

[lynnsong986]

Sorry never mind I forgot to throw in the application.enableevents = false before undo...