pause updates to window

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mansky99 - 02 Aug 2005 22:24 GMT

Hi ,
What command(s) to I use to pause output written to the ActiveWindow while
my VBA code runs on the ActiveDocument ? I am trying to avoid the end User
from seeing each update that is preformed on the ActiveDocument. I would like
to have my code run and complete it's work, then have the ActiveWindow
updated all at once. Can I do this ?

Thanks!

Ed

Reply to this Message

Pat Garard - 02 Aug 2005 22:52 GMT

g'Day,

Try::-

Sub DoSomething()
Application.ScreenUpdating = False
:
'Something happens here, but changes are not displayed
:
Application.ScreenUpdating = True
End Sub

Word remains visible, but no Screen Updating occurs.
You must also arrange to set ScreenUpdating to True
in the event of the Macro halting due to an Error (i.e. in
your Error Trap).

Signature

Regards,
Pat Garard
Melbourne, Australia
_______________________

> Hi ,
> What command(s) to I use to pause output written to the ActiveWindow while
[quoted text clipped - 6 lines]
>
> Ed

Reply to this Message

mansky99 - 02 Aug 2005 23:21 GMT

Thanks! Exactly what I was looking for.

> g'Day,
>
[quoted text clipped - 22 lines]
> >
> > Ed

Reply to this Message