Hi.
How stop macro after specifc time comes?
Please Login or Register to view this content.
Hi.
How stop macro after specifc time comes?
Please Login or Register to view this content.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Hi marreco,
I had success with the following.
ThisWorkBook Module:
Please Login or Register to view this content.
Ordinary Code Module (such as Module1):
LewisPlease Login or Register to view this content.
Hi LJMetzger work nice, thank you!!
I'll do some tests, but i want say thank you very much!!
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?
Thank you!!!Please Login or Register to view this content.
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):
Sheet1 Module (all new - important items in red):Please Login or Register to view this content.
Please Login or Register to view this content.
Ordinary Code Module:
Please Login or Register to view this content.
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 !!!!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks