All,
I have a document with an autosave on it, it saves every 15min.
Now is the problem :
When i close the excel file, it reopens and saves again. It remains open as well.
Can somebody help me how to get out of the autosave loop when the document is closed?
This is my autosave code :
Private Sub Workbook_Open()
Application.OnTime Now + TimeValue("00:15:00"), "SaveThis"
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Call SaveFinal
End Sub
Sub SaveThis()
Application.DisplayAlerts = False
ThisWorkbook.Save
Application.DisplayAlerts = True
Application.OnTime Now + TimeValue("00:15:00"), "SaveThis"
End Sub
Sub SaveFinal()
Application.DisplayAlerts = False
ThisWorkbook.Save
Application.DisplayAlerts = True
End Sub
Bookmarks