Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using the Application.ScreenUpdating = False?
Usually "application.screenupdating = false" does a nice job.
But there are some builtin routines that turn it back on (without your knowledge or consent). The best you can do is try to isolate these and put a "application.screenupdating = false" right after it gets changed. You may also want to double check to see if your routine calls another routine that turns screenupdating back on when it's done. (Maybe this is the real cause!) I'd pepper statements like: debug.print "step 99: " & application.screenupdating (varying the step #) throughout the code to help isolate the problem. Application.screenupdating and application.enableevents are two different things. .enableevents = false stops anything you're doing from firing another event (either the same even worksheet_change or a different one). Susan Hayes wrote: 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 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to set Application.ScreenUpdating = False for Gen use | Excel Discussion (Misc queries) | |||
Using the Application.ScreenUpdating = False? | Excel Programming | |||
Application.screenUpdating = False | Excel Programming | |||
Application.ScreenUpdating = False and it still flicker ! | Excel Programming | |||
Application.ScreenUpdating = False | Excel Programming |