Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
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 |