Chip Pearson shows how to use the OnTime method to run a macro.

http://www.cpearson.com/excel/OnTime.aspx


Gord Dibben MS Excel MVP

On Wed, 11 Feb 2009 13:32:01 -0800, Mel T ID <Mel T
wrote:

I have a spreadsheet that retrieves data from an external source. I need to
recalculate the spreadsheet at a regular interval, in this case 5 minutes.
Anyone know a fairly simple way to do this?