'Code has been Interrupted' error! Argh....

da_vide78

Board Regular
Joined
Mar 6, 2007
Messages
73
Something has happened to my VB Editor and i don't know what!!

I have a great document with some basic (They're fancy to me as i'm new to this) Macro's to speed up my need for formatting data i'm pasting into it. It was all working great until today - played around with some of the code (trying to learn how it works) and all of a sudden, ANY macro i run, it's stopping with a dialog box saying

'Code has been interrupted'

If i click 'continue' it carries on no problem, but if i look at the debug, it's highlighting a part of the code in yellow. It varies where it's stopping.

I've even tried to run fresh new macro's in a new spreadsheet but they#re doing the same. I've also tried a version which i know is bug free but that's doing it too.

Does anyone have any ideas or experienced this before?
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Watch MrExcel Video

Forum statistics

Threads
1,122,705
Messages
5,597,663
Members
414,162
Latest member
jborjal1967

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top