No, that isn't how Ontime works at all. It isn't on all the time. If fires
the macro and ends. If excel is busy, it won't fire the macro as it is not
preemptive. Depending on how you configure it, it can be allowed to try
again. See the help for details.

See Chip Pearson's page on ontime for some examples.

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy


"bondcrash" wrote:


Tom,

the macro "A" takes a fraction of a second to run - the "B" can be
several of them but no more than one at a time and those take a
fraction of a second to run as well. I think 5 secs is more than enough
to allow "B" to run. The problem, as I see it, is that the on-time macro
"A" is on all the time, even in between the five seconds event since it
waits for the next run, and I think "B" is not allowed to run untill
"A" is done but being an on-time means never... (or until i stop it).

I may run some individual macro's each to do the task and say print a
time on the sheet and whenever there are more than five secs re-run it
etc but the problem is in that case I need to have the time function
continuously going and I need an outside source for that because
otherwise the time is updated only at recalculation. Basically I am a
bit stuck.

Thanks for the suggestion Bob but basically I have several of them and
have no way to know which one/if any of the "B" will get triggered by
the latest download of "A" (I am basically back-testing a series and
see if it generates a signal).

Cheers guys
BC


--
bondcrash
------------------------------------------------------------------------
bondcrash's Profile: http://www.excelforum.com/member.php...o&userid=20997
View this thread: http://www.excelforum.com/showthread...hreadid=537175