LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Turning off screen update while macro runs


Hi,

I was wondering if there was a way to turn off the screen update while
a macro runs, and then to turn it on again once it is complete. Also,
does this help the throughut time at all?

Thanks for the help.


--
dancingflames
------------------------------------------------------------------------
dancingflames's Profile: http://www.excelforum.com/member.php...o&userid=27056
View this thread: http://www.excelforum.com/showthread...hreadid=482357

 
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
VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs Rruffpaw Setting up and Configuration of Excel 1 September 17th 11 01:25 PM
Long running macro and screen update James[_39_] Excel Programming 5 October 13th 05 01:39 PM
Run macro but let user update spreadsheet while it runs Ev Excel Programming 5 September 9th 05 07:57 PM
Flickering of the Screen when the Macro runs. Neeraja Excel Programming 3 October 28th 03 10:40 PM
Turning off Screen Refresh sullivan Excel Programming 7 October 1st 03 11:38 PM


All times are GMT +1. The time now is 07:14 PM.

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

About Us

"It's about Microsoft Excel"