Automated Macro Based on Timer Doesn't Kick Off

[blackscholes]

I setup a timer in a macro that I kickoff before I leave.

Application.OnTime TimeValue("05:00:00"), "AutoRunUpdate"

I already tested it and it seemed to work during the day. I basically just set the timer to kick off 2-3 mins after I press the button that contains this macro. It worked fine but when I do it at the end of the day before I leave, it doesn't run the folllowing morning. The macro should kick off at 5:00 AM.

Any suggestions? Does the process get killed after some time?

[nathansav]

Can you attach an example?

[blackscholes]

It's quite simple. I have a button that runs the Kickoff function and leave the Workbook open overnight. I cannot schedule the Windows Scheduler to open the Workbook. Does the OnTime process get cancelled? Maybe it doesn't work when the screen is locked? How about if Excel is "Calculating" cells that could be conflicting with the OnTime process? Any help is appreciated.

Sub Kickoff()
Application.OnTime TimeValue("05:00:00"), "AutoRunUpdate"
End Sub

Sub AutoRunUpdate()
....rest of code...
End Sub

[nathansav]

Is it on a button click? If youre opening the workbook, you'll need this in the Workbook_open() event.

[blackscholes]

It's in a button click. I'm not opening the workbook. I leave the workbook open overnight. I click the button and it runs. When I set it up to run 2-3 mins, it works but when I set it for 5 AM overnight, it doesn't.

[nathansav]

Can you attach the workbook?