AlexanderBB
Well-known Member
- Joined
- Jul 1, 2009
- Messages
- 2,134
- Office Version
- 2019
- 2010
- Platform
- Windows
I've been working on something for several days when suddenly I get error Code execution has been interrupted
Click debug and you can step through the code without any errors.
After mucking around for ages including a widows reboot I Googled and found
The solution for this problem is to add the line of code “Application.EnableCancelKey = xlDisabled” in the first line of your macro. This will fix the problem.
And they're right - it does. Take it out and the problem reoccurs.
But why? I never needed it until now. Anyone know what has changed/happened?
Click debug and you can step through the code without any errors.
After mucking around for ages including a widows reboot I Googled and found
The solution for this problem is to add the line of code “Application.EnableCancelKey = xlDisabled” in the first line of your macro. This will fix the problem.
And they're right - it does. Take it out and the problem reoccurs.
But why? I never needed it until now. Anyone know what has changed/happened?