Run Macro Every 30 min
 

I've got a macro that emails the current status of a project. I would like the macro to auto-run every 30 min. How do I do this? Thanks ahead of time

Bob

Run Macro Every 30 min
 

See Chip Pearson's page on the Ontime Method

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

--
Regards,
Tom Ogilvy

"Bob Ewers" wrote in message
...
I've got a macro that emails the current status of a project. I would
like the macro to auto-run every 30 min. How do I do this? Thanks ahead of
time.

Bob

Run Macro Every 30 min
 

Checkout the OnTime method www.cpearson.com/excel/ontime.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bob Ewers" wrote in message
...
I've got a macro that emails the current status of a project. I would
like the macro to auto-run every 30 min. How do I do this? Thanks ahead of
time.

Bob