View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Allan P. London, CPA Allan P. London, CPA is offline
external usenet poster
 
Posts: 11
Default VBA "Code execution interrupted" error on End Sub and End IF c0mmands??

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