Force macros to run one at a time

I have several macros being called by one button. The problem is that several of the macros being called have other macros that take a while to run and then end result is creating a PDF file that has not yet been updated.

I recall someone once showed me how to force excel to only run one at a time as a setting, but i cant for the life of me find the setting to change that. Anyone???

Maybe, if you post the code, we can help you?

This is not how it should work with pure VBA (not counting running external scripts, api calls, etc).

If you do something like the following:

Please Login or Register  to view this content.

Then it runs 1, then 2, then 2_1, then 3. 3 doesn't run until 2 and all its called routines complete.

The only time this may not be accurate is if you call a sub multiple times, in which case its a design issue not a matter of timing. IE: if you call a sub, and then later call it again anything in between is run...well in between. If whats in between relies on the 2nd call to the sub, then its a matter of better arranging your code.

Also, as I mentioned, some things run from VBA outside of Excel cant be properly kept track of in some cases. For example running something via cmd from VBA may not complete before VBA moves on. Sometimes you need to force the code to wait until something is complete that can be validated (ie: loop until file exists, when copying a file from one location to another). How you make it wait depends on the nature of what your doing and how. You can either create code to evaluate a measurable condition and loop until its true/false etc or you can tell VBA to wait X time before moving on which is a bad way to do it as something may take 10 seconds on your computer but 45 on someone elses.

Without code, samples, error messages, etc we cant really help you with specifics.