Sounds like you have set up a macro that uses the OnTime method.

See Chip Pearson's site for starting and stopping a macro.

http://www.cpearson.com/excel/OnTime.aspx


Gord Dibben MS Excel MVP

On Fri, 06 Feb 2009 20:00:08 +0100, Imda14u wrote:

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