Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

running macros silently

Forum home » Delegate support and help forum » Microsoft Word Training and help » Running macros 'silently'

Running macros 'silently'

ResolvedVersion 2007

James has attended:
Excel Advanced course

Running macros 'silently'

Although I learned of this trick in an Excel course, I'm posting it in the Word forum, as it's just as relevant to Word.

At a recent Excel 2007 Advanced course, the instructor (I think it was Peter) showed an instruction that can be added to a macro so that it doesn't display the drawing of actions on screen, but instead simply generates the end result.

But I can't find the instruction! Can someone please post this command? Thanks.

James

RE: Running macros 'silently'

Hi James, thanks for your query. The line of code is:

Application.Screenupdating = False

Best practice is to switch it back on again at the end of the code:

Application.Screenupdating = True

Hope this helps,

Anthony

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Word tip:

How to Adjust the Line Spacing in Word 2010

To change the line spacing in a Word document, you can apply a Quick Style set.

1) Click Change Styles on the Home tab
2) Go to Style Set and point your cursor to the various style sets
3) You will see how the line spacing changes from one style to the next
4) When you spot a spacing you want, click the name of the style set

View all Word hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.