What I would like to do is automatically run a macro that displays a reminder (message box) to save and close the workbook the user is in by 3:40pm (assuming they have it open). Here is the code I'm using:
Sub SetAlarm()
Application.OnTime TimeValue("03:40:00"), "DisplayAlarm"
End Sub

Sub DisplayAlarm()
MsgBox "Please Save and Close Your Workbook by 3:40pm!"
End Sub
I can't get this to work at all! The Sub DisplayAlarm works if I run it manually so I know that's not the problem. I haven't been able to successfully get the Application.OnTime event to run at all. I've tried testing it with various times and it doesn't seem to do anything. I don't understand why it wouldn't work for me. I'm using Excel 2010 on Windows 7 Enterprise Service Pack 1.

Please help! Thanks!

Trey