Running a macro within a macro with a message box

[koltregaskes]

I have 4 macros that create 4 reports. I have a 5th macro that runs all 4 macros so creates all 4 reports if I need them all.

All macros have a message box pop up to day they're complete. Of course this means the 5th "all reports" macro has 4 "I'm complete" message boxes".

I really only want one message box to appear for the "all reports" macro. Is there a clever way to suppress the 4 individual messages boxes?

If we could run more than one macro per button than it would be easy but of course we can't.

[snb]

Why don't you use Excel's statusbar instead ?

[Domski]

One way:

Please Login or Register  to view this content.

Dom

[snb]

or

Please Login or Register  to view this content.