Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Screen Refresh | Excel Discussion (Misc queries) | |||
refresh van uw screen commando | Excel Programming | |||
Screen refresh problem. | Excel Programming | |||
Screen refresh problem. | Excel Programming | |||
Screen Refresh after minimize | Excel Programming |