Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro stopping
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro stopping
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" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro stopping
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/sh...d.php?t=196743 http://www.thecodecage.com/forumz |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro stopping
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro stopping
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro stopping
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/sh...d.php?t=196743 http://www.thecodecage.com/forumz . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro stopping
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/sh...d.php?t=196743 http://www.thecodecage.com/forumz |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro stopping
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. |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro stopping
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 |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro stopping
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. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stopping a macro | Excel Programming | |||
Stopping A Macro | Excel Programming | |||
Stopping a macro | Excel Programming | |||
Stopping a Macro | Excel Programming | |||
My Macro keeps stopping?? | Excel Programming |