Use the OnTime method.
See Chip Pearson's site for code.
http://www.cpearson.com/excel/OnTime.aspx
Gord Dibben MS Excel MVP
On Sun, 11 Jan 2009 01:07:40 +0800, "sun" wrote:
Dear Excel Gurus,
Can I set a timer to run a macro at regular time intervals? Is there a
convenient API to use?
Thank you very much in advance.