How to change an event handler on error

[alanb1976]

Hi all
I've tried to read up on some error handling but everything I've brought up just confuses me more.
I got some code that sets the event handler to false so that the code can run uninterrupted.

Please Login or Register  to view this content.

Unfortunately, I got some problems where I run into errors when pasting blocks of information (works fine on single cells). When that happens it leaves the event handler as false as it hasn't reached the code to enable it again. So I have to manually go and enable it again. This is fine for me, but the users won't know how to do that. While I figure out how to correct my mistakes, is there a way of running a line of code if an error happens? Or does anyone know a Error Handling for Dummies site?
Thanks
Alan

[buran]

Hi
This is nice article about basic error handling.

http://www.cpearson.com/Excel/ErrorHandling.htm

You need an error handler where you will change EnableEvents property to TRUE

Hope it helps

[alanb1976]

Thanks. That is a lot simpler explanation to the previous ones I read