Run Macro Every 30 min

B

Bob Ewers

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
 
B

Bob Phillips

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 said:
I've got a macro that emails the current status of a project. I would
Click to expand...
like the macro to auto-run every 30 min. How do I do this? Thanks ahead of
time.
 
Top