running macro in background

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EstherH - 31 Jul 2005 18:00 GMT

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.

Reply to this Message

Anne Troy - 31 Jul 2005 18:24 GMT

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

> Hi,
>
[quoted text clipped - 7 lines]
>
> Thanks in advance for any help.

Reply to this Message

EstherH - 31 Jul 2005 18:46 GMT

Thanks loads. It works perfectly.

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

Reply to this Message

Anne Troy - 31 Jul 2005 18:52 GMT

Cool beans. :)
*******************
~Anne Troy

www.OfficeArticles.com

> Thanks loads. It works perfectly.
>
> I knew it had to be easy. But I didn't think this easy.

Reply to this Message

Rate this thread: