Go Back   Computer Forums > General Computing > Software and Operating Systems
Click Here to Login
Join Computer forums Today

Thread Tools Search this Thread Display Modes
Old 11-17-2011, 05:33 AM   #1
Fully Optimized
ssc456's Avatar
Join Date: Jan 2007
Posts: 4,279
Send a message via MSN to ssc456
Default Code Execution Has Been Interupted

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?
He who has never failed has never attempted anything worth succeeding at.

Dont Eat Animals, Its Not Good For Them And They Dont Like It!
ssc456 is offline   Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

All times are GMT -5. The time now is 07:09 PM.

Powered by vBulletin® Version 3.8.8 Beta 4
Copyright ©2000 - 2018, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0