Don't show macro processing

  • Thread starter Thread starter dhstein
  • Start date Start date
D

dhstein

How do I disable the macro processing window - in other words, I don't want
the user to see all the screen flashing as the macro is running. Thanks for
any help on this.
 
application.screenupdating = false

It generally turns itself back on when the macro finishes, but its good
practice to set it to true at the end to ensure it turns back on.

Cheers
Simon
Excel development website: www.codematic.net
 
Hi

At the top of your code use this:

Application.ScreenUpdating=False

and remember to set it = True at the end of your code.

Without seeing your code, I suspect that you may have some .Select and
..Activate statements in your code, which you often don't need ( it is also
slowing down your code).

Hopes this helps.
....
Per
 
Back
Top