Hi,

I have a Macro which runs for around 2 min. Two Excel
sheets are involved in this Macro. When the Macro runs,
the user sees the screen flickering and the focus keeps
shifting between the screens... all the while the macro
runs i.e for around 2 minutes. I also included a progress
bar in the macro, so the user sees the progress bar while
the macro runs, but the screen keeps flickering under
this progress bar all the while and this is very
disgusting to watch.
I want the focus to be on some blank screen (which does
not flicker) with the progress bar.
what do i do to achieve this. Could someone help me out
with this!!

Thanks in advance for any help.
Regards,
Neeraja.