View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default 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.