use
APPLICATION.ONTIME

Help shows how

Sub StartTimer()
Application.OnTime TimeSerial(8, 15, 0), "WakeUp"
End Sub
Sub WakeUp()
MsgBox "Time to Go!"
End Sub


"Kyriaki" wrote:

Hi
I have an excel that contains a macro and I want that macro to run
automatically at the time I want. For example I have my pc open and I want to
run automatically this macro at 10:00 am. Without to need to press any
button. Is there any way to do that from Excel code?? Or is there any other
way??
Please let me know!

Thanks a lot