View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
ste mac ste mac is offline
external usenet poster
 
Posts: 117
Default Conditional macro execution

"Willis Marsh" wrote in message ...
Is there a way I can fire a macro based on time of day?
i.e 08:10

Thanks in advance,


Hi Willis... this was posted by Rob van Gelder it may be of some help...

seeya ste

Sub ScheduleMe()
Application.OnTime Now() + TimeValue("00:00:05"), "RunMe"
End Sub

Sub RunMe()
Beep
ScheduleMe
End Sub