Code execution has been interrupted in Excel

[Vineeta]

Hello friends,

I am facing some issue with Excel file, whenever i try to open excel file which contain macros, over there i am getting an error message as code execution has been interrupted. If i try to open it in Excel 2003 then it's open properly without any issue, i am facing this issue only with Excel 2007. Does anyone have any suggestions?

[Capers]

One of my friend was also getting Code execution has been interrupted, after finding a lot we came to know that macro security is set too high because of which he was getting error message, it might happen that you are also having same thing, for that you need to set macro security to Medium will prompt you enable or disable macros.

[Vineeta]

Thanks for replying me Capers, i have tried to change security level for macro but still i am getting the Code execution has been interrupted error message, does anyone know any other solution apart from changing security level.

[Crona]

I know that many people get Code execution has been interrupted when they are trying to open macros files in Excel 2007, in that case i would suggest you to disable cancel key will not work because the thing breaks before it even runs the function and you have to restart your computer. After doing this if you are still facing any issue then try to use the following code

Application.EnableCancelKey = xlDisabled