ssc456
Fully Optimized
- Messages
- 4,280
Ok guys i've googled this one and it seems there are literally hundreds of forums on this and i've searched through alot of them and not found a solution and i'm wondering if we have the knowledge here to resolve.
Here's my problem i've got an excel spreadsheet with some VBA code in it which i've developed at work and it's being rolled out across the business to a couple of hundred users! The problem is while running one fo the macros the user will occasionally get an erorr to stat the "Code execution has been interupted" now if the user clicks on continue (usually several times) the macro finishes without any errors?
This isn't limited to just one user!
I've tried added the Application.EnableCancelKey = xlDisabled into the beginning of the code and it did work on one of them but i have around 20 or 30 difference subs in here and yes it will be a workaround but does anybody actually know what the solution is or why it is caused?
Here's my problem i've got an excel spreadsheet with some VBA code in it which i've developed at work and it's being rolled out across the business to a couple of hundred users! The problem is while running one fo the macros the user will occasionally get an erorr to stat the "Code execution has been interupted" now if the user clicks on continue (usually several times) the macro finishes without any errors?
This isn't limited to just one user!
I've tried added the Application.EnableCancelKey = xlDisabled into the beginning of the code and it did work on one of them but i have around 20 or 30 difference subs in here and yes it will be a workaround but does anybody actually know what the solution is or why it is caused?
