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