I have a person that gave me their spreadsheet which they use for manufacturing production. At the start of a shift, the shift supervisor presses a "Start of Shift" button. They asked me to place an autosave macro in there so it backs up throughout the day. I put the following macro in:
Sub AutoSave()
Application.DisplayAlerts = False
ThisWorkbook.Save
Application.DisplayAlerts = True
Application.OnTime Now + TimeValue("00:10:00"), "AutoSave"
End Sub
They have added an "End of Shift" button and it has things it does when they press that. They have asked me to turn off the autosave function when that button is pressed.
How do I turn off the macro? I can't figure out how to deactivate it.
Thank you for your help.
Mike
Sub AutoSave()
Application.DisplayAlerts = False
ThisWorkbook.Save
Application.DisplayAlerts = True
Application.OnTime Now + TimeValue("00:10:00"), "AutoSave"
End Sub
They have added an "End of Shift" button and it has things it does when they press that. They have asked me to turn off the autosave function when that button is pressed.
How do I turn off the macro? I can't figure out how to deactivate it.
Thank you for your help.
Mike