Disable Screen Redraws

[Bruce Roberson]

I'm setting up a new PC for a new employee and installing
macros on their machine.

In testing these macros, I am noticing that the screen
flickers for redraws whereas it did not on my machine.

This one that flickers is using Excel 2002, and my machine
uses Excel 2000. Is there some application setting I need
to set that will stop these redraws as the macro processes?

Thanks,


Bruce Roberson

 

[Beto]

I'm setting up a new PC for a new employee and installing
macros on their machine.

In testing these macros, I am noticing that the screen
flickers for redraws whereas it did not on my machine.

This one that flickers is using Excel 2002, and my machine
uses Excel 2000. Is there some application setting I need
to set that will stop these redraws as the macro processes?

Use "Application.ScreenUpdating = False" at the begining of your code.

Regards,

 

[Guest]

Ok, I was hoping there was another way. I was aware of
what you are saying. The screen redraws on my machine
didn't seem as obvious I guess.