running macro in background

E

EstherH

Hi,

I have a fairly complicated macro that does a lot of text editting. I don't
want to see what is happening as the macro runs (it takes a few seconds). I
would just like to see the end result. So I would like to have the macro run
in the background during execution of the commands and then at the end to
display the entire file as modified.

Is this possible? Would anyone know how to do this?

Thanks in advance for any help.
 
A

Anne Troy

Hi, Esther. Generally speaking, you should be able to put the first line of
code near the beginning of your code and the 2nd line of code near the end
of your code. However, to my knowledge, it's not nearly as nice in Word as
it is in Excel.

Application.ScreenUpdating = False
Application.ScreenUpdating = True
*******************
~Anne Troy

www.OfficeArticles.com
 
E

EstherH

Thanks loads. It works perfectly.

I knew it had to be easy. But I didn't think this easy.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top