'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?
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,871
Messages
5,834,140
Members
430,261
Latest member
quangtinator

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