Progress Bar

  • Thread starter Thread starter John
  • Start date Start date
J

John

Is it possible to see a Progress bar when a Macro is running, particularly
when its a big macro instead of the screen 'blinking'


Thanks
 
blinking can probably be eliminated by
application.screenupdating=false
code
application.screenupdating=true

also turn off auto calculation and turn it back on at the end


If you STILL need a progress bar
http://tinyurl.com/2nv9a
 
Thanks Don, what code would I use to turn on/off Auto Calc function? and by
turning the AC off at the start of code and on at the end not effect my
figures?
 
Record a macro when you do:

Tools|options|Calculation Tab
Change calculation to manual.

then do it again, but change it to automatic

and you'll have your code.

And I think you'll see that it works fine when you're testing it.
 
A good time to learn how to use vba HELP. Look in the INDEX for
CALCULATION.method
 
Thanks Dave, thats a handy piece of code


Dave Peterson said:
Record a macro when you do:

Tools|options|Calculation Tab
Change calculation to manual.

then do it again, but change it to automatic

and you'll have your code.

And I think you'll see that it works fine when you're testing it.
Click to expand...
 
Back
Top