Have a look here for how to schedule a macro repeatedly after a set time:

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

Dom