View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ken Wright Ken Wright is offline
external usenet poster
 
Posts: 634
Default How to abort executing macro?

Have you tried CTRL+BREAK?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"perfb" wrote in message
om...
is there a way to provide a button that will always abort the
VBA execution?

e.g. am executing multiple loops, with calls to time delay functions,
(data acquisition loop), and while this is running, the worksheet
buttons are dead. Even if I have the Visual Basic window open,
I cant use the 'stop' button while the time delay function is
executing, it wont respond for some reason.

I would like a way to preemptively abort execution, e.g. a separate
watchdog process/thread?

tia!



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.703 / Virus Database: 459 - Release Date: 10/06/2004