Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Code Execution has been interupted
I have written a macro within excel. Works really well but can take up to an
hour to process. Problem is that every now and again, I get the message "code execution has been interupted". I read the help file and this does not help. I am not pressing "Ctrl-break" or any other combination of keys. In fact I am not even touching the keyboard at the time! Anyone any clues as to why this might happen? The macro does access some other spreadsheet, but these are no opened by anyone else at the time (they are all on my C drive). Help anyone? |
#2
|
|||
|
|||
Without seeing the code, it would be nigh impossible to help!
"Rich" wrote: I have written a macro within excel. Works really well but can take up to an hour to process. Problem is that every now and again, I get the message "code execution has been interupted". I read the help file and this does not help. I am not pressing "Ctrl-break" or any other combination of keys. In fact I am not even touching the keyboard at the time! Anyone any clues as to why this might happen? The macro does access some other spreadsheet, but these are no opened by anyone else at the time (they are all on my C drive). Help anyone? |
#3
|
|||
|
|||
In fact I am not even touching the | keyboard at the time!
Even so, the macro is stopping as if you hit Esc. I cannot imagine what is causing this but you can try to deal with the symptoms with this: Application.EnableCancelKey = xlDisabled After this Esc will not stop the macro (which you may not like) and perhaps this will stop the pseudo-Esc too. -- Jim "Rich" wrote in message ... |I have written a macro within excel. Works really well but can take up to an | hour to process. Problem is that every now and again, I get the message | "code execution has been interupted". | | I read the help file and this does not help. I am not pressing "Ctrl-break" | or any other combination of keys. In fact I am not even touching the | keyboard at the time! | | Anyone any clues as to why this might happen? | The macro does access some other spreadsheet, but these are no opened by | anyone else at the time (they are all on my C drive). | | Help anyone? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) |