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: 31
Default Using the Application.ScreenUpdating = False?

Hi again

My second question!

I am trying to stop the screen from flickering during calculation when program runs.
I have tried this by putting it at the beginning (false) and end (true) of a sub() but still flickers
Application.ScreenUpdating = False

My program has for loops that execute less then100 times and some if/else select/case statements. Some cells change
color and values are deleted aswell.
-its running on a p3

Any advice?

Application.EnableEvents = False seems to do a better job in the Worksheet_Change then the above but still get some
flickering

Thanks

Mike



 
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
How to set Application.ScreenUpdating = False for Gen use David_Williams_PG () Excel Discussion (Misc queries) 1 August 15th 06 12:06 PM
Using the Application.ScreenUpdating = False? Susan Hayes Excel Programming 0 January 29th 05 03:50 AM
Application.screenUpdating = False Pamhall Excel Programming 1 December 17th 04 03:19 PM
Application.ScreenUpdating = False and it still flicker ! Gunnar Johansson Excel Programming 5 September 8th 04 02:42 PM
Application.ScreenUpdating = False Pieter Kuyck Excel Programming 2 July 15th 03 06:28 PM


All times are GMT +1. The time now is 03:12 AM.

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"