How do I run a Macro, but not watch it run?

B

BK

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.
 
V

Vasant Nanavati

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

Bob Phillips

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)
 
Top