When you reschedule, you'll need to calculate the next Monday, Tuesday,
Saturday or whatever day you want the macro to run.

Be aware that OnTime does not persist after you've closed Excel. The macro
only runs if Excel is running too.
You need to reset OnTime every time you open the workbook.

Rob


"mushy_peas " wrote in message
...
how about days of the week
for example i want to run a particualr marco at diff times in the days
depending if its Mon - Thurs, and another for Sat-Sun


---
Message posted from http://www.ExcelForum.com/