How to run Macro without seeing what it's doing?

[mgri]

Hi all,

I'd like to run my macro without actually seeing the screen flick between the various worksheets it selects during its run time. Is this possible?

Thanks very much!

Brian

[wmorrison49]

Just add

Application.ScreenUpdating = False

at the beginning of your code

[Tarball]

Remember to turn it back on

Please Login or Register  to view this content.

[mgri]

That's great, thanks to both of you.

[wmorrison49]

What happens if you don't add it back on at the end? I never do and I have never noticed any problems.