Is there a way by using Auto_Close to exit from the macro the Autpen has started to play?
Probebly I don't have the best syntax, but I does the job . I have an Autpen that calls a macro which start another macro at a certain time. The problem I have is that If I exit from the workbook that need this functionality and open it once more it produces two Picture_copying macro, so I thought it would be possible to kill the first macro call when closing the workbook.
Probebly I don't have the best syntax, but I does the job . I have an Autpen that calls a macro which start another macro at a certain time. The problem I have is that If I exit from the workbook that need this functionality and open it once more it produces two Picture_copying macro, so I thought it would be possible to kill the first macro call when closing the workbook.
Code:
Sub Auto_Open()
Call Time_to_copy
End Sub
Code:
Sub Time_to_copy()
Application.OnTime ("10:16:00"), "Picture_copying"
End Sub