Thread: Screen suspend
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J. Sleeman J. Sleeman is offline
external usenet poster
 
Posts: 2
Default 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