All Macros broken

[Shecansueme]

All the macros I have created have seemed to stop working for both me and my coworkers.

Seems like even "End Sub" is causing code to be interrupted.

I poked around about the 2014 update issues but I believe we should be past any of those issues.

Any guidance on where to start looking is highly appreciated.

[6StringJazzer]

No way to know without seeing your macros. Even better, can you attach your file? Are you getting compile errors or runtime errors? What error message are you getting when the code is interrupted?

Anything else in your environment change when the problem started? How are you sharing your macros with your co-workers?

[Shecansueme]

Its the gray screen that says code execution has been broken.
In some of them I can continue through after going to the debugger in others it gets hung up.

This one gets hung up on the first "End With"

Please Login or Register  to view this content.

[6StringJazzer]

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #3 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer

[6StringJazzer]

Whenever execution stops, the "gray screen" has an error message on the first line. What's the error messag?

[Shecansueme]

"Code execution has been interrupted"

[Trebor76]

Hi Shecansueme,

See if replacing this line of code at the start of your code...

Please Login or Register  to view this content.

...with this does the trick:

Please Login or Register  to view this content.

Regards,

Robert

[mgs73]

Try this when you get 'Code execution has been interrupted':

Press 'Debug', then Ctrl-Break twice. Press F5 to continue and save.

[Shecansueme]

Thanks for the help on this. Adding the below code

Please Login or Register  to view this content.

this seemed to do the trick on the file I posted.
I added the same code to other macros and it worked. But on another it doesn't display 'Code execution has been interrupted' but now freezes somewhere around the paste code I think.

Please Login or Register  to view this content.

Overall I'm a little confused as to why this all started to happen all of a sudden.

[mgs73]

While

Please Login or Register  to view this content.

does prevent the 'Code execution has been interrupted' message, it also prevents you from using Ctrl-Break to debug your code.

[Shecansueme]

If I remove

Please Login or Register  to view this content.

Excel still freezes halfway through and if given time to recover shows that it broke around:

Please Login or Register  to view this content.

Is there something in my environment that may have gotten changed that is causing all of these issues?

[skywriter]

Just glancing at your code, you are doing a lot of activating and selecting, which is unnecessary and slows your code down.

Also this line:

Please Login or Register  to view this content.

Selects every cell on a worksheet, which is probably causing your computer to be unhappy. I would suggest referring to actual ranges that need to be copied and not using activate and select and especially not selecting and copying every cell on a worksheet.

[Shecansueme]

Thanks for the help skywriter I'll definitely try and trim it down. But it had been running smoot
I spoke with our IT department and they did make some updates through security patches over last weekend. They claim nothing should have been changed in Excel, but I wonder if it was something inadvertent to change Excel.

[mgs73]

I don't think this is a problem you will get to the bottom of, unfortunately. I've seen this issue every so often on every version of Excel I have used over the past decade or so. Ctrl-Break twice plus F5 fixes it for me when I come across it. Before I learned that trick, resetting the computer would also generally fix it.

I second skywriters comments on selecting, activating, etc... I would also add that when working with more than one workbook or worksheet, it is very important to clearly identify which workbook or worksheet a range is part of. This might help get you started:

Please Login or Register  to view this content.