View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jean-Yves[_2_] Jean-Yves[_2_] is offline
external usenet poster
 
Posts: 253
Default stop screen refresh

Hi,

application.screenupdating=false
As you won't see anymore what is going on, you can use the statusbar to
diplays your info text
from the help fileoldStatusBar = Application.DisplayStatusBar
Application.DisplayStatusBar = True
Application.StatusBar = "Please be patient..."
Workbooks.Open filename:="LARGE.XLS"
Application.StatusBar = False
Application.Displa+yStatusBar = oldStatusBarRegards,Jean-Yves"Gordon"
wrote in message
...
The macro that I have developed is running slower than I would like

because
it involves a very large amount of printing to the screen. The speed of

the
macro is thus limited by the graphics card rather than the Intel

processor.

Is there any way of making the macro run in such a way that it only
refreshes the screen at the end of the macro?