View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Scheduling Macro run

When you schedule it for the next cycle, check the current time, if it is
5:15, set the next time to 6:00pm.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"axwack" wrote in message
...
Folks,

I am using the onTimer methods for scheduling the automation of a
macro to be run. I need to turn it off from 5:15 to 5:59pm every day
and then restart at 6:00pm until 5:15pm the next day.

Is there a way to do this? How would you do this?