Me00550
07-22-2020, 07:38 AM
can someone please explain to me why this simple macro wont work unless i manually activate it? i want it to start the timer as soon a user opens the workbook
Sub OnTime()
Application.OnTime Now + TimeValue("00:15:00"), "CloseMe"
End Sub
Sub CloseMe()
ThisWorkbook.Save
ThisWorkbook.Close
End Sub
Sub OnTime()
Application.OnTime Now + TimeValue("00:15:00"), "CloseMe"
End Sub
Sub CloseMe()
ThisWorkbook.Save
ThisWorkbook.Close
End Sub