View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
susan hayes susan hayes is offline
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