Hi,

I personally feel that it might take up unecessary system resource

Are you usign a user form by any chance? If you are using a user form you
could use a progress bar to show the status?

Anand



"Madhavan" wrote:

Hi all,
I have a macro which does some kind of analysis for about 5 mins and
displays the result in a new sheet. I need to display a background animation
or a video file until the macro completes its operation. Is it possible to do
this using Excel VBA or is it out of scope of excel? If it is possible either
by excel or by any other means, pls send me the procedure to do same.
Hope i will get a reply this time.
Thanks a lot in advance.