Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to Diagnose Why "Code Execution has been interrupted" Neal Zimm Excel Programming 1 January 23rd 08 04:20 AM
How to ged rid of the "Execution Error 9" message at the file opening? frenchbox Excel Discussion (Misc queries) 0 July 31st 06 03:28 PM
error: Code Execution has been interrupted Joshua Fredrickson Excel Programming 1 November 23rd 05 03:44 PM
"Code execution has been interupted" Dennis Fry Excel Programming 2 September 17th 03 08:29 PM


All times are GMT +1. The time now is 11:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"