Hiding Word when executing a Macro

[moontho]

I now have a lovely long procedure that's doing everything that i want it, i.e grabbing bookmarked information from lots of other documents on a monthly basis and combining it into one monthly report.

It's just that it looks a little messy when it running with the screen flashing away like crazy.

Is there any code that can help stop this problem?

Many thanks

Thom

 

[Loomah]

Hi
I've never used these in Word but you could try either of the following

Application.ScreenUpdating = False
Application.Visible = False

;-)

If a man says something and there are no women there to hear him, is he still wrong?
How do I get the best answers?​

 

[Molby]

Try

Application.ScreenUpdating = False

then

Application.ScreenUpdating = True

at the end of the macro.

 

[moontho]

Loomah. That's done the trick. Thanks. All looking very slick and professional now.