This is so weird to me. We run a macro to update information in 60 cash files each day. We'd had problems with people leaving their cash sheet files open, which kept them from being updated, so I put a timer in each of the files that launches a message at 4:29pm that the file will save and close automatically at 430pm. The weird part is that if you open one of these files at any time during the day, close it and do not open it again, the message will still pop up on your screen at 4:29pm AND you'll find the same file you opened earlier is now open on your desktop! All of the coding was cobbled together, so my ability to analyze it is limited. Also, we are on a network, and I wonder if that has something to do with it. Any thoughts would be appreciated. Here's all the coding I added to the file:

ThisWorkbook

   Private Sub Workbook_Open()
    
    Application.OnTime TimeValue("16:29:00"), "warning"
    Application.OnTime TimeValue("16:30:00"), "test"
Sub Warning()       
    
With ufMsgBox

    .StartUpPosition = 0
    .Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width)
    .Top = Application.Top + (0.5 * Application.Height) - (0.5 * .Height)
     ufMsgBox.Message = "This file will close in one minute to allow  for the Daily Deposits upload at 4:30 pm." & vbNewLine & "  " & vbNewLine & "  " & vbNewLine & " Please allow 15 minutes for the upload to complete."
        .Show
             
End With

End Sub
Sub test()

Application.DisplayAlerts = False

'close WB with saving:

ThisWorkbook.Close SaveChanges:=True

End Sub