Popup Progress Indicator

[David W]

How do you put an automatic progress indicator in your sheet or program so
the individual can't see the changes being calculated until their done. I
have had people to freak out when the sheet is recalculating itself,
especially when the sheet jumps back and forth. Thanks David

 

[Tom Ogilvy]

At the top of your code put in

application.ScreenUpdating = False

and at the bottom

Application.ScreenUpdating = True

the above will stop the screen from jumping around. Another approach is to
not use constructs like select and activate in your code.


There is no automatic progress indicators - there are progress indicators,
but you have to use code to control what they display.