Screen suspend
 

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

--
Message posted from http://www.ExcelForum.com

Screen suspend
 

Hi
try the following
Sub foo()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
'...
'enter your code
'...
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
end sub


--
Regards
Frank Kabel
Frankfurt, Germany
"eyecalibrate " schrieb
im Newsbeitrag ...
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?


---
Message posted from http://www.ExcelForum.com/

Screen suspend
 

-----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?


---
Message posted from http://www.ExcelForum.com/

.

Application.screenupdating = false

'Your code

Application.screenupdating = true