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!
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.
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
Thanks for replying, Artik. I have tried the solution proposed by WBD, hopefully that will work.
Your help is greatly appreciated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Programmernovice 
Register To Reply
Bookmarks