View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default Run macro at specified time

Maybe you didn't see my first post?:

Mushy,

You may want to play with Application.OnTime

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

Sub RunMe()
Beep
ScheduleMe
End Sub


Rob


"mushy_peas " wrote in message
...
im sure i saw somewhere where it was really ease, it was just like one
line. basically do this at this time and that was it.

Chips, that all looked too much for me little brain too habdle. Hmm oh
well, i'll see.

Thanks anyway :O)


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