CODEWITHSUNDEEP
vbams-word
Sam
Sam

Reputation: 28999

How to disable screen update in long running word macro?

I've got a word 2013 macro which is taking quite some time to finish.

The macro is reformatting the document and the Screen keeps updating while the macro is running, which I guess is where word spends most of it's time.

How can I disable screen updating in word in a macro and refresh it when the macro is finished?

Upvotes: 4

Views: 7844

Answers (1)

Kazimierz Jawor
Kazimierz Jawor

Reputation: 19067

Try with adding this line at the beginning of your code:

Application.ScreenUpdating = False

and this at the end:

Application.ScreenUpdating = True

If this doesn't help you need to add more information and possibly post your code.

Upvotes: 10

Related Questions