View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Imda14u Imda14u is offline
external usenet poster
 
Posts: 6
Default code to stop all running macro's

Hi all,

in my workbook i have created links to realtime stockquotes.
i created a macro that does a fullcalculation every minute until 1700 hrs.

Now, what i need is code to stop all running macro's. i tried the quit
method, but id don't want excel to quit. i just want to stop all macro's
when i click a button (no Ctrl+break)

Any help is greatly appreciated.

TIA

Sybolt