Turning off display while VBA running
Try:
Application.ScreenUpdating = False
Application.ScreenUpdating = True
At the beginning and at the end of your code.
If your code calls other code to do some "stuff" then you may still get
screen flickering as that code excetutes, so you may need to include
Application.ScreenUpdating = False
Application.ScreenUpdating = True
in that called code also.
Also knowing that once you go to the other called code the
Application.ScreenUpdating = False is now negated in the original code and
when the code comes back to the next line of the original code and you may
get screen flickering again as it continues.
HTH
Regards,
Howard
"Bob Bridges" wrote in message
...
Seems to me I once saw an option I can turn off to keep Excel from
updating
the display while my program inserts rows, fills in data, hides/unhides
rows
and such, so it'll run faster if there's a lot to be accomplished...the
idea
being that the program will turn the display, so to speak, back on just
before it gets to End Sub. Now I want to use that feature and I can't
find
it in my VBA/Excel chm. Can anyone tell me where to look for it? Thanks.
|