automatically run a macro at a specific time

[garygooba]

This is now officially driving me mad!!
I am trying to get a macro to run automatically every 10 or 15 minutes while I have the workbook open (Excel 2010). This is the code that isnt working for me

Please Login or Register  to view this content.

Any help would be grateful

[Chippy]

Put Macro2 in a standard module. http://www.cpearson.com/excel/OnTime.aspx shows how to reschedule the macro periodically.

[garygooba]

great solution and works, but would you know how to set start and end times. So I can run it automatically every 5 minutes bewteen 10:00 and 11:00