Divad
03-17-2009, 03:49 AM
I am using Excel 2003. When i run some of my macros, i get an error message saying 'Code execution has been interrupted'. It appears randomly and if i press continue the code carries on running.
I have searched google and many people have had the same problem but i cannot find a definative fix. If you put
Application.EnableCancelKey = XlEnableCancelKey.xlDisabled
infront of the macro it will disbale the error. The problem there is i would need to put that on all my code and i also have some workbooks that i didn't create that have userforms pop up when the workbook opens and the code is password protected, so i cannot enter the code, and cannot open the workbook
This problem is restricted to my machine, all macros that display this error work fine on other machines, so there is nothing wrong with the code.
Has anyone else come accross this and fixed the problem?
Thanks
I have searched google and many people have had the same problem but i cannot find a definative fix. If you put
Application.EnableCancelKey = XlEnableCancelKey.xlDisabled
infront of the macro it will disbale the error. The problem there is i would need to put that on all my code and i also have some workbooks that i didn't create that have userforms pop up when the workbook opens and the code is password protected, so i cannot enter the code, and cannot open the workbook
This problem is restricted to my machine, all macros that display this error work fine on other machines, so there is nothing wrong with the code.
Has anyone else come accross this and fixed the problem?
Thanks