Stop an Auto_Open macro

Wilke

New Member
Joined
May 12, 2009
Messages
3
Is there a way by using Auto_Close to exit from the macro the Auto_Open has started to play?

Probebly I don't have the best syntax, but I does the job :). I have an Auto_Open 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
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Forum statistics

Threads
1,224,503
Messages
6,179,135
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top