macro stopping
in [Programming]
|
From: JOSEPH WEBER on 19 Apr 2010 15:08 All of my macros are pausing at various points. Is there a control somewhere that I may have hit by mistake? Is there any way to stop it from doing this? It gives me the option to continue, but I don't want to have to keep pressing continue.
From: Rick Rothstein on 19 Apr 2010 15:15 Are there any lines in your code that are highlighted in red? If so, those lines are designated as break points and your code will stop on them. If you have them and want to remove them, just click on the "red dot" next to them in the gray left-hand border for that code window. Another reason your code might stop is if you have a Stop statement in your code... that statement will also evoke a break in your code. -- Rick (MVP - Excel) "JOSEPH WEBER" <JOSEPHWEBER(a)discussions.microsoft.com> wrote in message news:C64BFBE1-13D4-4186-87D2-DE55BEC047C2(a)microsoft.com... > All of my macros are pausing at various points. Is there a control > somewhere > that I may have hit by mistake? Is there any way to stop it from doing > this? > It gives me the option to continue, but I don't want to have to keep > pressing > continue.
From: p45cal on 19 Apr 2010 15:21 What's the code that is highlighted? Is there an error message? Is there a brown blob on the left of the code where it stops? Does it say "Debug.Assert..." J O S E P H W E B E R ; 7 0 3 1 9 0 W r o t e : > All of my macros are pausing at various points. Is there a control somewhere > that I may have hit by mistake? Is there any way to stop it from doing this? > It gives me the option to continue, but I don't want to have to keep pressing > continue. -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?u=558 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=196743 http://www.thecodecage.com/forumz
From: EricG on 19 Apr 2010 15:57 Can you provide some more details? What exactly is the message you are getting? Is it presented in a dialog box? What is the title of the dialog box (at the top of the box)? Is there actually a button labeled "Continue"? If instead you do have a bunch of break points in your VBA code, then go into the VB Editor, and select "Clear All Breakpoints" from the "Debug" menu and that will remove them. Eric "JOSEPH WEBER" wrote: > All of my macros are pausing at various points. Is there a control somewhere > that I may have hit by mistake? Is there any way to stop it from doing this? > It gives me the option to continue, but I don't want to have to keep pressing > continue.
From: JOSEPH WEBER on 19 Apr 2010 16:11
Wish i could do a print screen. The title is Microsoft Visual Basic. The message is Code execution has been interrupted. I have buttons of "Continue", "End", "Debug" and "Help". I don't have any breakpoints in the code. This happened to me before and I put in: Application.EnableCancelKey = xlDisabled, but i don't want to do that to every macro I have and plus I may need to stop it for some reason or another. "EricG" wrote: > Can you provide some more details? What exactly is the message you are > getting? Is it presented in a dialog box? What is the title of the dialog > box (at the top of the box)? Is there actually a button labeled "Continue"? > > If instead you do have a bunch of break points in your VBA code, then go > into the VB Editor, and select "Clear All Breakpoints" from the "Debug" menu > and that will remove them. > > Eric > > "JOSEPH WEBER" wrote: > > > All of my macros are pausing at various points. Is there a control somewhere > > that I may have hit by mistake? Is there any way to stop it from doing this? > > It gives me the option to continue, but I don't want to have to keep pressing > > continue. |