Run macro 2 after the running of macro 1 is finished (running macro 1 takes some second)

Dear Professionals

I wish to combine 2 macros, 1st macro named (clean),2nd macro named (New)

code of 1st macro as follow:

Please Login or Register  to view this content.

code of 2st macro:

Please Login or Register  to view this content.

SUPPOSE, 1st macro take 10 second to finish loading.

I wish to add some code between 1st and 2nd macro, and COMBINE two macro into one. (run 2nd macro ONLY after excel is not busy (finished loading for the 1st macro).

Can anyone provide the magic code required for linking up the 2 macros please?

Thank you very much.

Dear mehmetcik

Thank you first, but where i should place these lines? It looks like it is a macro itself.

Dear Mehmetcik

Thank you very much, it works perfect.

Please Login or Register  to view this content.