Thread: MACROS WONT RUN
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
dk[_2_] dk[_2_] is offline
external usenet poster
 
Posts: 21
Default MACROS WONT RUN

On Aug 19, 1:28*am, JOSEPH WEBER
wrote:
I have several macros I use on *a daily basis and I tried to run them and
they give me an error of "Code execution has been interrupted" *Can someone
tell me why I could be getting this message? I didn't hit contrl break and
have no idea what else i could have done wrong. *


This happens most of the times when you offen debug using CTRL +
BREAK, you put the following line in your macro:

Application.EnableCancelKey = xlDisabled

to avoid this.


-DK