pause updates to window

[mansky99]

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

 

[Pat Garard]

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).

 

[mansky99]

Thanks! Exactly what I was looking for.

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).
--
Regards,
Pat Garard
Melbourne, Australia
_______________________