VBA - Go To Error Handler if Macro Interrupted

[vba_monkey]

Hello,

Is there a way to make excel Go To my Errorr Handler if Esc is pressed half way through a macro running?

This is to make sure things like Events and Screen Updating are turned back on if a macro doesnt reach it's end and does it itself.

Thanks

 

[MrKowz]

Check out this article:

EnableCancelKey Property [Excel 2003 VBA Language Reference]

 

[vba_monkey]

Perfect, thank you.