VBA "Code execution interrupted" error on End Sub and End IF c0mmands??

  • Thread starter Allan P. London, CPA
  • Start date
A

Allan P. London, CPA

Folks,



For some reason my VBA programs have suddenly stopped working properly? I
get a "code execution interrupted" error. If I select continue, execution
continues with no problem. If I select debug the highlighted "error" code
is always an END IF, NEXT or END SUB command? The code runs just fine on my
other computers.



Also, this is not new code, I have been using some of these workbooks for
years without trouble. And, I have the same problem with ALL my workbooks
that have VBA code. I tried rebuilding Excel and re-compiling the code and
using Code Cleaner to copy the code to a text file and back into the VBA
editor. Nothing sees to fix the problem.



One possibility is that I run both Office 2007 and Office 2003 on my
machine. But I have been running "parallel" for about a year with no
problems? This problem started a few days ago? Also, I get the same problem
in Excel 2007 workbooks.



I am afraid that if I reinstall Office 2003, then I will need to also
reinstall Office 2007. Is that the only way to fix the problem assuming the
VBA has some corruption problem?



Thanks for the help



Allan P. London, CPA

alondon (no spam)@alondon,com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top