Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Screen Refresh Michael H Excel Discussion (Misc queries) 4 November 8th 05 04:46 PM
refresh van uw screen commando Matthias Excel Programming 1 December 23rd 03 03:35 PM
Screen refresh problem. Nigel Brown[_2_] Excel Programming 0 September 17th 03 03:21 PM
Screen refresh problem. Nigel Brown[_2_] Excel Programming 0 September 17th 03 02:15 PM
Screen Refresh after minimize Kent Prokopy[_3_] Excel Programming 0 August 22nd 03 06:34 PM


All times are GMT +1. The time now is 12:10 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"