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/