Running macros 'silently'

Resolved · Low Priority · Version 2007

Wed 15 Dec 2010, 15:50 Delegate James said...

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

Wed 15 Dec 2010, 17:32 Trainer Anthony said...

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

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Word tip:

Inserting a blank row above a table at the top of a page

This only works if you have created your table at the top of a page.

Go into the first cell and make sure cursor is at start of cell (if you have typed in it) and press RETURN this then puts a blank line above your table.

View all Word hints and tips