Suppressing display when running macros.

Harry Audus · Sep 17, 2004

How can I suppress the display of operations (ie stop flashing) when running
a macro, especially one that accesses more than one worksheet?

Norman Jones · Sep 17, 2004

Hi Harry,

Try:

Application.ScreenUpdating = False

'Your Code

Application.ScreenUpdating = True