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