Don't show macro processing
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.
|