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