Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need macro that will BREAK a running macro
I have a macro that runs, and its pretty lengthy. I would like to create a macro that I will attach to a Command Button that will stop a macro that is currently running. One that works in the same way the break key works. I tried using the SendKeys {Break} but that didn't seem to work. Is it possible to run a macro while another is running? What's the code to do what I am looking to do? Thanks in advance for any help, -- grime ------------------------------------------------------------------------ grime's Profile: http://www.excelforum.com/member.php...o&userid=19227 View this thread: http://www.excelforum.com/showthread...hreadid=387599 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need macro that will BREAK a running macro
That is because until the macro suspends, the toolbar button has no effect.
Catch-22. What you can do is to add DoEvents throughout the code, which yields execution so that the operating system can process other events. -- HTH Bob Phillips "grime" wrote in message ... I have a macro that runs, and its pretty lengthy. I would like to create a macro that I will attach to a Command Button that will stop a macro that is currently running. One that works in the same way the break key works. I tried using the SendKeys {Break} but that didn't seem to work. Is it possible to run a macro while another is running? What's the code to do what I am looking to do? Thanks in advance for any help, -- grime ------------------------------------------------------------------------ grime's Profile: http://www.excelforum.com/member.php...o&userid=19227 View this thread: http://www.excelforum.com/showthread...hreadid=387599 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable running of SelectionChange macro when in another macro? | Excel Discussion (Misc queries) | |||
Event Macro running another macro inside | Excel Discussion (Misc queries) | |||
disable user running macro from Tools Macro | Excel Discussion (Misc queries) | |||
Stop running a macro in the middle of a macro | Excel Programming | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming |