View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Alan Alan is offline
external usenet poster
 
Posts: 188
Default 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.