I just finished a long project in excel of preparing report from huge data.
The entire project was broken into different macro because of its requirment.
Each macro actually hits a other application to bring in data.

Now i have about 20 macros which i run and final report get generated. I
have a master macro which calls all the macros.

like

SUb mainstart()

call macro1
call macro2
call macro3
call macro4

End sub

First problem:

If i insert screenupdating false in the start and screenupdating true in the
end of the master macro, it does not helps. Still we see macro doing some
activity in the middle.

Second problem:

I wish to get some idea about the macro which is running, can we diplay the
name of the macro which is running on the userform.
or some kind of progress button to help user understand that how much time
in left.

This forum had helped me most is getting things done. Please help..
Thanks!
Boss