Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I programmatically simulate clicking the 'stop macro' button in the VBE?
Can I simulate the clicking of the stop button in the VB Editor using VBA? Thanks, Alan. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I programmatically simulate clicking the 'stop macro' button i
Hello,
For effect, you could use the The End Statement. See: http://msdn.microsoft.com/en-us/vben...l/vastmEnd.asp It's use is typically frowned upon. Regards, Nate Oliver |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I programmatically simulate clicking the 'stop macro' butt
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I programmatically simulate clicking the 'stop macro' button in the VBE?
I have never used the stop button, but if you want to just stop code
execution, use Ctrl + C, Esc, or Break key. -- Regards, Tom Ogilvy "Alan" wrote in message ... Can I simulate the clicking of the stop button in the VB Editor using VBA? Thanks, Alan. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I programmatically simulate clicking the 'stop macro' button in the VBE?
Hi Alan;
You can try: DoEvents Application.VBE.CommandBars.FindControl(ID:=228).E xecute MP "Alan" a écrit dans le message de ... Can I simulate the clicking of the stop button in the VB Editor using VBA? Thanks, Alan. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I programmatically simulate clicking the 'stop macro' button in the VBE?
Sorry, misread your post. (I actually couldn't find a stop button, but
Michael interpreted it as the Reset button). What are you trying to achieve. -- Regards, Tom Ogilvy "Tom Ogilvy" wrote in message ... I have never used the stop button, but if you want to just stop code execution, use Ctrl + C, Esc, or Break key. -- Regards, Tom Ogilvy "Alan" wrote in message ... Can I simulate the clicking of the stop button in the VB Editor using VBA? Thanks, Alan. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I programmatically simulate clicking the 'stop macro' button in the VBE?
For me, I needed to put the DoEvents after the Execute command.
-- Regards, Tom Ogilvy "Michel Pierron" wrote in message ... Hi Alan; You can try: DoEvents Application.VBE.CommandBars.FindControl(ID:=228).E xecute MP "Alan" a écrit dans le message de ... Can I simulate the clicking of the stop button in the VB Editor using VBA? Thanks, Alan. |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I programmatically simulate clicking the 'stop macro' button in the VBE?
Yes Tom, you are right.
MP "Tom Ogilvy" a écrit dans le message de ... For me, I needed to put the DoEvents after the Execute command. -- Regards, Tom Ogilvy "Michel Pierron" wrote in message ... Hi Alan; You can try: DoEvents Application.VBE.CommandBars.FindControl(ID:=228).E xecute MP "Alan" a écrit dans le message de ... Can I simulate the clicking of the stop button in the VB Editor using VBA? Thanks, Alan. |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I programmatically simulate clicking the 'stop macro' button in the VBE?
"Tom Ogilvy" wrote in message
... Sorry, misread your post. (I actually couldn't find a stop button, but Michael interpreted it as the Reset button). What are you trying to achieve. Hi Tom, I have a spreadsheet with some event driven code (worksheet change event specifically). This is also a shared workbook. Occasionally, a user gets a 'Document Not Saved' message when they try to save. I believe that this is being caused by an event driven code somehow hanging or getting into some kind of loop, stopping the user saving. We are reviewing the code, but in the meantime, I wanted to give the users a way to effectively click on 'reset' in the VBE (without having to know anything about the VBE), to stop / reset any runnning code, and effect a save. I have used the line supplied by Michel ...) amended to include a 'Do Events' after it as you suggested in reply to that posting, so I will see if that gets the users saving again next time it occurs. Thanks, Alan. |
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I programmatically simulate clicking the 'stop macro' button in the VBE?
"Michel Pierron" wrote in message
... Yes Tom, you are right. MP "Tom Ogilvy" a écrit dans le message de ... For me, I needed to put the DoEvents after the Execute command. -- Regards, Tom Ogilvy "Michel Pierron" wrote in message ... Hi Alan; You can try: DoEvents Application.VBE.CommandBars.FindControl(ID:=228).E xecute MP Hi Michel, That looks to be exactly what I need. Thank you very much. Regards, Alan. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Macro to sort without clicking on macro button | Excel Discussion (Misc queries) | |||
Start/Stop Macro Button | Excel Discussion (Misc queries) | |||
Macro Record Stop Button | Excel Discussion (Misc queries) | |||
Programmatically Adding Controls (Macro) eg Button on A SpreadSheet | Excel Programming | |||
how to add code programmatically to a macro for a button | Excel Programming |