Friday, October 1, 2010

Excel: "code execution has been interrupted" Message

If your excel macro is running in interruption mode then you will get code execution has been interrupted message. You can disable this error in two types.
1.       Use this code in your program Application.EnableCancelKey = xlDisabled.
2.       Press Ctrl + Pause Break key.
Note: Generally this interruption will occur to all excel workbooks because of interruption flag is set in your Excel environment. Press Ctrl+Break during execution of macro to disable this interruption mode.