how to keep macros from running at the same time?

I posted this question yesterday, but didn't word it very well, so I closed that thread and thought Id see if anyone can give me insight with the question worded like this... With the code below, what can I add to make sure that the macro that runs every 5 minutes, does not fall at the exact same time as my other macros? It must have happened the other day, because it took formatting from one of my workbooks, and applied it to another workbook. Each of those workbooks get opened from a macro and things done, so for it to have happened, it had to have been trying to run both macros at the same time, and did the formatting to the wrong workbook. Any Help?

Please Login or Register  to view this content.

Hi - I do not believe it is possible to run two excel macros at the same time. VBA is a single-threaded language so it cannot run two pieces of code simultaneously. This assumes that all the macros are being run from the same application instance.

I'd therefore suggest you need to post more information about the project, for example, the other macros involved and some of the workbooks in order to arrive at a solution.

Could you give me an example of how to do this? Below is the code from one of the macros, just clearing some cells. What can I add to it, to make sure that it only does it to this ThisWorkBook? Thanks

Please Login or Register  to view this content.

Instead of:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

or to stop needing to right it out each time:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

That said, you can probably amalgamate all those ranges, i.e.

Please Login or Register  to view this content.

Thanks, seemed to have worked great!