qondio.com/6BE3 PRINT EMAIL
Excel error: code execution has been interrupted By Fritz Barnes I recently started getting many, many occurrrences of the message "code execution has been interrupted" when running Excel macros. The message is exactly the same as if I had pressed Ctrl-Break to halt macro execution, for example, if I wanted to enter Debug mode. But I was getting this message spontaneously and randomly. The line of code that was active could be anything. Apparently the problem was caused by moving some macros from one module to another. Somehow this threw off Excel's pointers to where the macros were stored and caused unstable results. The solution was to save the macros to another location (I copied them into notepad), delete the VBA module that contained them, close the Excel file, re-open the file, add a new module, and copy the code back in.

Contributed by fritzbarnes on April 1, 2009, at 4:45 PM UTC.

PLEASE VISIT THE CONTRIBUTOR'S WEBSITE

Transcend Technologies We are Essbase experts. transcend-tech.com

Reactions

No reactions yet.

Rate This Intel

Please login or sign up to rate this intel.

Comments

Please login or sign up to add a comment.

Share

Copyright Notice

The copyright for this content entitled "Excel error: code execution has been interrupted" has been specified by the contributor as:

Creative Commons Attribution-Share Alike 3.0 Details

This content may be copied, distributed, and modified, as long as a) the original author is acknowledged with a link back to the content page, and b) if the work is modified, the result is distributed with this same license. If you use this content according to the license specified, you must link to the following URL:

http://fritzbarnes.qondio.com/

Login Here with Any Email Address Any Password Remember login No account? Sign up.

Intel Contributor

This intel was contributed by fritzbarnes

Qondio Archive

May, 2012 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 2008 January, February, March, April, May, June, July, August, September, October, November, December 2009 January, February, March, April, May, June, July, August, September, October, November, December 2010 January, February, March, April, May, June, July, August, September, October, November, December 2011 January, February, March, April, May, June, July, August, September, October, November, December 2012 January, February, March, April, May

Sign Up

Not a member yet? Qondio is a powerful network for making it online. If you have a website to promote, we can help. Sign up and get in on the action.

About Qondio

Welcome to Qondio! Discover the awesome power this network can deliver by going to our About page. Or you could skip straight to the Sign Up form.