"Code execution has been interrupted" Error

[Speshul]

I started getting this error on all of the macros I have in one particular sheet. I am not pressing anything that could interrupt the code, the error comes up almost immediately. Normally the macro takes about 2 seconds to run.

The code itself is not the issue as far as I can tell, I have not modified the code in weeks, and had a backup of the previous version which worked flawlessly, now causes errors.

Here is an example of the code being highlighted, the variables are all assigned correctly, I stepped in with a tracker open and everything was fine.

Please Login or Register  to view this content.

Another sheet seems to like to lock up on an "End With" statement(??)

Please Login or Register  to view this content.

The only thing I have done is add a data source to ODBC, but I am not sure how this could cause errors in VBA that never referenced a DB in the first place?



Thanks
cei.PNG

[olle3770]

Hello

Definetly a peculiar problem,

Have you googled it? First hit suggests this solution, sounds quite strange.

http://stackoverflow.com/questions/2...as-been-halted

[Speshul]

Thanks, Debug - Control + Break x 2 worked. I didn't get this result when i googled the message, I got a unhelpful TeachExcel result and a dead-end msdn post...guess I should have scrolled down more. hmph.

I'd love to know what the underlying problem is being caused by, I have novice users who use my programs, I don't know if I want them exposed to unprotected VBA code....