Stop macro after specifc time comes

[marreco]

Hi.

How stop macro after specifc time comes?

Please Login or Register  to view this content.

[LJMetzger]

Hi marreco,

I had success with the following.

ThisWorkBook Module:

Please Login or Register  to view this content.

Ordinary Code Module (such as Module1):

Please Login or Register  to view this content.

Lewis

[marreco]

Hi LJMetzger work nice, thank you!!

I'll do some tests, but i want say thank you very much!!

[marreco]

Hi

Based your attachment, i need change trigger to run macro "Main_Macro"

The "Main_Macro" only run after cells change, but i need automatically stop this "Main_Macro" when #9:27:00 AM# comes?

How i automatically stop this macro?

Please Login or Register  to view this content.

Thank you!!!

[LJMetzger]

You need a software flag to tell Main_Macro that the time has expired. See the attached sample worksheet and the code that follows. Important changes are in red. In the Main_Macro() routine, you can add or delete checks that 09:27 has arrived as required.

Please note that Main_Macro() will NEVER run when the value of bScheduledTimeCompleted is 'True'. If you want to run Main_Macro() without the timer running, you have set the value to 'False' before running Main_Macro().

Lewis

ThisWorkbook module (no changes):

Please Login or Register  to view this content.

Sheet1 Module (all new - important items in red):

Please Login or Register  to view this content.

Ordinary Code Module:

Please Login or Register  to view this content.

[marreco]

Hi LJMetzger

I like their solution, their knowledge is generally fantastic !!

can't click twice in star, but i try another way..

very thank you !!!!!!!!!!