Screen Update

  • Thread starter Thread starter BP
  • Start date Start date
B

BP

Good morning,
Can you refresh me on the code that stop the screen from showing everything
that's happening in the macro? For instance, as cells are being selected
and updated via the macro, don't actually show this on the screen.

Thanks in advance.
 
Hi
Application.ScreenUpdating = False / True
you may also consider using
Application.Calculation = xlCalculationManual / xlCalculationAutomatic
So in total:
-----
Sub foo()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
'...
'enter your code
'...
Application.ScreenUpdating = False
Application.Calculation = xlCalculationAutomatic
end sub
 
Back
Top