Chip Pearson describes how to use OnTime:
http://www.cpearson.com/excel/ontime.htm

But you may have to change your macros to avoid interaction.

ewagz wrote:

I am looking for a way to automate excel macros to run on a 30 min intervals
without interaction. Is there a code for this?
--
EW - Analyst

--

Dave Peterson