Don't show macro processing

[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.

 

[Mike H]

Hi,

application.screenupdating=false

'your code

application.screenupdating=true

Mike

 

[Simon Murphy]

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

 

[Per Jessen]

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

 

[dhstein]

Thanks for the answers.

Hi,

application.screenupdating=false

'your code

application.screenupdating=true

Mike