code to stop all running macro's

[Imda14u]

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

 

[Imda14u]

Thanks Gord,

As amatter of fact I haven't used the onTime method.
The code loops each minut until a specified time is reached.

It stops automatically, but i clock a button to get it start running.

I also want a button to interrupt the loop.

I'm gonna have a look at Chip's ideas.

greets

Sybolt