Application.OnTime not working after converting from Excel 2010 to Excel 2016

  • My simple run requests were working just fine until the 2016 excel upgrade. I tried to enable and disable options but nothing seems to be working.


    Workbook:
    Private Sub Workbook_Open()
    Application.OnTime TimeValue(13:30:00), "Refresh"
    Application.OnTime TimeValue(13:31:00), "Shutdown"
    End Sub


    Module:
    Sub Refresh()
    ActiveWorkbook.RefreshAll
    End Sub


    Sub Shutdown()
    ActiveWorkbook.Save
    ActiveWorkbook.Close
    End Sub

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!