macro stopping
in [Programming]
|
From: JOSEPH WEBER on 19 Apr 2010 16:23 There is no rhyme or reason to it. It just stops after a couple of lines. "p45cal" wrote: > > 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..." > > > JOSEPH WEBER;703190 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. > > > -- > 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 16:48 Have you tried something as simple as rebooting or shutting down and powering up your PC? "JOSEPH WEBER" wrote: > 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.
From: p45cal on 19 Apr 2010 16:47
perhaps you have 'Break on all Errors' selected in the General tab of the Options Dialogue box under Tools|Options in the Visual Basic Editor? -- 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 |