macro stopping

[JOSEPH WEBER]

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.

 

[Rick Rothstein]

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.

 

[p45cal]

What's the code that is highlighted? Is there an error message? I
there a brown blob on the left of the code where it stops? Does it sa
"Debug.Assert..."

All of my macros are pausing at various points. Is there a contro
somewhere

 

[EricG]

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]

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.

 

[JOSEPH WEBER]

There is no rhyme or reason to it. It just stops after a couple of lines.

 

[p45cal]

perhaps you have 'Break on all Errors' selected in the General tab o
the Options Dialogue box under Tools|Options in the Visual Basi
Editor?

 

[EricG]

Have you tried something as simple as rebooting or shutting down and powering
up your PC?

 

[Brian Murphy]

Dear Joseph,

Do you have Adobe Acrobat installed on your computer?
I have had Acrobat installed for years, and just several days ago I
started having this problem in Word 2003, and now today in Excel 2003.

Acrobat places menu items and toolbars into both Word and Excel, and
it does this is some sort of sneaky way since there are no Acrobat
addins that I can find.

Perhaps it is possible that an Acrobat software update created my
problem. Rebooting does resolve it for a while.

Brian Murphy
Austin, Texas

 

[GS]

Brian Murphy formulated on Sunday :

Dear Joseph,

Do you have Adobe Acrobat installed on your computer?
I have had Acrobat installed for years, and just several days ago I
started having this problem in Word 2003, and now today in Excel 2003.

Acrobat places menu items and toolbars into both Word and Excel, and
it does this is some sort of sneaky way since there are no Acrobat
addins that I can find.

Perhaps it is possible that an Acrobat software update created my
problem. Rebooting does resolve it for a while.

Brian Murphy
Austin, Texas

I'm pretty sure they use a COMAddin that's configured for all MSO apps.
You may find it listed in the COMAddins dialog and if so, you can clear
its checkbox if you don't want it installed.

You may have to add the COMAddins menuitem to the Tools menu via the
Customize dialog.