Is it a good idea to insert "ApplicatiionEnableEvents = false" VBA code to prevent macros from stopping or otherwise malfunctioning when others are running? I seem to be having problems of this type and would appreciate any advice or suggestion on how to deal with it. Many thanks in advance.
Last edited by AliGW; 09-27-2021 at 05:46 PM.
If you have macros that trigger when cell contents change and then you have other macros that change the contents of those cell then you can get into some difficulty. I sometimes disable events when I'm updating cell contents or doing anything else that might trigger another macro.
WBD
Office 365 on Windows 11, looking for ✶ rep!
Specifically, if you have a Worksheet Change Event handler and that event handler makes changes on the sheet, you should bracket the change(s) with ApplicatiionEnableEvents = False and ApplicatiionEnableEvents = True.
Similarly, if you have a Selection Change Event handler, and you select cell(s) within it, same rules.
In the worst case, it can cause a loop. Best case, it will fire more often than it needs to.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks. My problem seems to be related to different macros running on different schedules. If a macro begins while another is running, should that be a problem? Do these macros execute simultaneously, or do they do so in some kind of queue? Thanks again for your help.
Not a clue. Hypothetical questions with no example code or sample workbooks are difficult, if not impossible, to answer. Probably a poor analogy, but it's a bit like asking "what would happen if I drive very fast on a winding road when it's raining hard and I turn the steering wheel sharply?"
If your macros are running on timers then perhaps you should have a global variable that prevents two macros running at the same time. Like:
Then, at the start of each macro:
Please Login or Register to view this content.
Then at the end of the macro:Please Login or Register to view this content.
WBDPlease Login or Register to view this content.
If you run the second macro during the execution of the first macro, the execution of the first one is suspended until the end of the second one. VBA does not support multithreading.Originally Posted by Programmernovice
It is true that there are some possibilities of achieving multithreading, but this is already a higher driving school.
Artik
Many thanks WBD. Some of my macros are, indeed, running on timers. I have added the code you suggested, hopefully that will correct the problem.
I reatly appreciate your helping me out.
Thanks for replying, Artik. I have tried the solution proposed by WBD, hopefully that will work.
Your help is greatly appreciated
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thanks for the rep.
Thanks for the suggestion TMS I will try it out now. I appreciate your input.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks