HELP!!! "Code execution has been interrupted"

[x-amount]

But I havent pressed anything!!!

There is definite problem, as the "Code execution has been interrupted" error message appears seemingly at random (although if the workbook doesnt change it is the same points), and for no reason.

If I click the continue button the macro runs exactly as planned, but still there seems to be no rhyme or reason as to why this happens!?

It even invokes on the workboon_open function.

Any ideas???

 

[Joe4]

Could you post the code, indicating at what line the error occurs (when it happens)?

 

[x-amount]

Its a massive project, with userforms and bits.

If any "guru" really fancies a challenge (which has got me well and truly baffled (and I thought I was quite advanced!)) then I am more than happy to email it to them...

Otherwise, I am continually doing exactly this

 

[Joe4]

Well, without seeing any code, or at least having further description of the conditions under which the error occurs, it is very difficult to offer any assistance.

Could you at least post the code that is being interrupted up to the point where it is being interrupted?

 

[x-amount]

the macro stops literally as i open the workbook , and highlights the "Private Sub Workbook_Open()" line as the point of error.

has anyone ever heard of a similar problem? I'm tending to think it may be a setting I've fiddled with??

 

[Joe4]

What is your macro security level set to (Tools | Options | Security | Macro Security)?

Also, what do the first few lines of your Workbook_Open macro look like?

 

[x-amount]

It works ok on another users computer, so I assume its a problem with my settings somewhere.

Thanks for your help

 

[TommyGun]

Post the Workbook_Open code.

 

[Jeminar]

This is the bain of my life too.

I have this problem too. It is a real head banger. WHY? The line of code works one day and then randomly stops. Like the previous user, there is NO rhyme or reason. Code that was worked for months or years stops on innocuous lines. Pressing continue makes it work again. I just run code with my finger on the C button.

And yet this seems completely undialogued on Google or elsewhere.

The problem does not replicate on other computers very often (yes, again completely randomly).

Now, it's started hapenning to me in Word; and I have a COMPLETLY NEW LAPTOP with completely new code. What can I be doing wrong? On this computer I HAVE NEVER SET A WATCH.



Some-one must know this problem and have a resolution. I've been fighting it for a year now, and I promise you: it has NOTHING to do with the code itself.

 

[maxmadx]

just a thot.

new pc, new code... hmmm. All else being constant, automatic or manual updates like microsoft commonly release might be messing with key files no? might be that the other people's PCs havent or have had certain updates that you have or havent had.. not very likely but u never know.