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?
|