Hide macro execution?

[RogerC]

I have a single macro that takes action on many different worksheets? Is there a technique that would allow you to run the macro, but not actually see the worksheets as it is running among them? In other words, run the macro but only see the sheet from which it was started until it is done running?

 

[brettvba]

Hi Rodger,

add this line to your code
application.screenupdating = false

then after the code

application.screenupdating = true

Brett

 

[cmlebron]

This worked great. Thank you!

Hi Rodger,

add this line to your code
application.screenupdating = false

then after the code

application.screenupdating = true

Brett