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.

Hi,

application.screenupdating=false

'your code

application.screenupdating=true

Mike

"dhstein" wrote:

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


dhstein wrote:
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.

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" skrev i meddelelsen
...
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.

Thanks for the answers.

"Mike H" wrote:

Hi,

application.screenupdating=false

'your code

application.screenupdating=true

Mike

"dhstein" wrote:

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.