Does anyone have any idea if there is a way to run a macro, but to not
be able to see what it's doing. In other words, when the macro is
run, the screen will not go through the entire process, but will
simply reflect the changes when the prcedure is finished. Is there a
way to do that?

Thanks for any help you can offer.

Application.ScreenUpdating = False
'Run macro
Application.ScreenUpdating = True

--

Vasant


"BK" wrote in message
om...
Does anyone have any idea if there is a way to run a macro, but to not
be able to see what it's doing. In other words, when the macro is
run, the screen will not go through the entire process, but will
simply reflect the changes when the prcedure is finished. Is there a
way to do that?

Thanks for any help you can offer.

Precede the code with

Application.Screenupdating = False

and reset to True at the end.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"BK" wrote in message
om...
Does anyone have any idea if there is a way to run a macro, but to not
be able to see what it's doing. In other words, when the macro is
run, the screen will not go through the entire process, but will
simply reflect the changes when the prcedure is finished. Is there a
way to do that?

Thanks for any help you can offer.