98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Word Training and help » Running macros 'silently'
Running macros 'silently'
Resolved · Low Priority · Version 2007
Wed 15 Dec 2010, 15:50Delegate 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:32Trainer 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Word tip:Inserting a blank row above a table at the top of a pageThis only works if you have created your table at the top of a page. |
