Hey,
Can someone help me figure out how to make this code loop so that it saves my worksheet every 24 hours:
Private Sub Workbook_Open()
'This will run the code 1 minute after the worksheet is opened
Application.OnT ime Now + TimeValue("24:0 0:00"), "SaveData", , True
End Sub
Onthefly
Can someone help me figure out how to make this code loop so that it saves my worksheet every 24 hours:
Private Sub Workbook_Open()
'This will run the code 1 minute after the worksheet is opened
Application.OnT ime Now + TimeValue("24:0 0:00"), "SaveData", , True
End Sub
Onthefly