Screen suspend

  • Thread starter Thread starter eyecalibrate
  • Start date Start date
E

eyecalibrate

I have a 13 page macro running during which the program switches bac
and forth between sheets. I don't want to see this and I don't want t
slow my computer with displaying this action. How do I suspend th
display, freeze it on the present page or whatever to solve this issue
 
Hi
try the following
Sub foo()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
'...
'enter your code
'...
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
end sub
 
-----Original Message-----
I have a 13 page macro running during which the program switches back
and forth between sheets. I don't want to see this and I don't want to
slow my computer with displaying this action. How do I suspend the
display, freeze it on the present page or whatever to solve this issue?
Click to expand...
Application.screenupdating = false

'Your code

Application.screenupdating = true
 
Back
Top