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

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.

--
Regards,
Tom Ogilvy


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