If you put Application.ScreenUpdating = False at the start of your macro
code, that should freeze the screen until the macro is completed. Not sure
what effect this will have on your progress bar, depending on where and how
it is displayed.

Rodg2000

(remove the _nospam to email)

"Neeraja" wrote in message
...
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.