This might get you started.
Paste in ThisWorkbook module
Paste in standard module![]()
Private Sub Workbook_Open() Application.OnTime Now + TimeValue("00:05:00"), "AutoSave" End Sub
![]()
Sub AutoSave() Application.DisplayAlerts = False ThisWorkbook.Save Application.DisplayAlerts = True Application.OnTime Now + TimeValue("00:05:00"), "AutoSave" End Sub
Bookmarks