4
votes

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?

1

1 Answers

10
votes

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.