Hello everyone
Please can anyone help me make this code work? I want the macro to pop up alert at specific times during the day. At the moment when I hit F5 it runs but on it's own it doesn't run at the set times. The module I used is 'This Workbook'. Any help to tweak this will be much appreciated. Thanks
Code
Sub MessageTime1()
Application.OnTime TimeValue("11:00:00"), "ShowMessageMidday"
End Sub
Sub ShowMessageMidday()
MsgBox "Mid-day Statement run starts in an hour"
End Sub
Sub MessageTime2()
Application.OnTime TimeValue("13:00:00"), "ShowMessage_afternoon"
End Sub
Sub ShowMessage_afternoon()
MsgBox "Afternoon Recs in 30min"
End Sub
Sub MessageTime3()
Application.OnTime TimeValue("14:00:00"), "ShowMessage_settle"
End Sub
Sub ShowMessage_settle()
MsgBox "Review settlement starts in an hour"
End Sub
Sub MessageTime4()
Application.OnTime TimeValue("16:35:00"), "ShowMessage_EOD"
End Sub
Sub ShowMessage_EOD()
MsgBox "EOD in starts in an hour"
End Sub
Display More