How can I automate a macro to run in timed intervals

I have created a macro in Excel and I want to be able to have it run
automatically on a timed interval that I can specify. e.g., Run automatically
every minute, every five minutes, every hour, etc.

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

--
HTH

Bob Phillips

"Randc" <Randc@discussions.microsoft.com> wrote in message
news:68B2A550-FDB4-401E-9EC6-06053F174747@microsoft.com...
> I have created a macro in Excel and I want to be able to have it run
> automatically on a timed interval that I can specify. e.g., Run
automatically
> every minute, every five minutes, every hour, etc.

See Chip Pearson's page on Application.Ontime

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

--
Regards,
Tom Ogilvy


"Randc" <Randc@discussions.microsoft.com> wrote in message
news:68B2A550-FDB4-401E-9EC6-06053F174747@microsoft.com...
> I have created a macro in Excel and I want to be able to have it run
> automatically on a timed interval that I can specify. e.g., Run
automatically
> every minute, every five minutes, every hour, etc.