Code always interrupted. Have to press Continue constantly

[gkeppler]

Whenever I run any of my macros, I get the error message "Code Interruption" or something like that, and I have to press the Continue button many times for the code to finish. The code runs without this error on other computers. I don't think I've changed any of my settings recently, but this problem seemed to appear out of the blue a couple weeks ago. Thanks.

 

[schielrn]

I would assume you have shut down and re-started your computer. I have seen this posted many times and recently had it happen to me a couple weeks ago and most people a re-start fixes the problem. Not sure why or what causes this to happen, but like I said it happened to me a few weeks ago for the first time in 3 years.

 

[Richard Schollar]

If it continues after a reboot, then try placing the following line at the start of your macro code:

Application.EnableCancelKey = xlDisabled

 

[gkeppler]

Thanks guys, I'll give both a go.

 

[Just2Help]

The same thing just happened to me with code that I have been running for months. The offending lines are... (1) Set objWkBk = Workbooks(Workbooks.count), and (2) objWkBk.Close False. I do not know what to do. I am running Excel 10. Any advise would be greatly appreciated.