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.

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@discussions.microsoft.com> wrote in message 
news:C64BFBE1-13D4-4186-87D2-DE55BEC047C2@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. 

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

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.

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.

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

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

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.