Vb6 turn off screenupdating
I've found in the many long Excel calculations most of the time waiting is having Excel update values on the screen.
If this is the case, you could insert the following code at the front of your sub: I've found that this often speeds up whatever code I'm working with so much that having to alert the user to the progress is unnecessary.
You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Turning Off Screen Updating.
Allen Wyatt With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. Are you ready to harness the full power of Word 2013 to create professional documents?
He is president of Sharon Parq Associates, a computer and publishing services company. In this comprehensive guide you'll learn the skills and techniques for efficiently building the documents you need for your professional and your personal life.
Check out Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? If you use a later version of Word, visit our Word Tips site focusing on the ribbon interface.
is your source for cost-effective Microsoft Word training.
(Microsoft Word is the most popular word processing software in the world.) This tip (749) applies to Microsoft Word 97, 2000, 2002, and 2003.
Many people write their own macros to manipulate their documents.
Screen Updating = False ''//Turn off screen updating boo Status Bar State = Application.
Display Status Bar ''//Get the statusbar display setting Application.
Many times the macro may do quite a bit with the document, such as jumping to different places, replacing text, and taking other types of actions.
This means that the Word screen can look like it has "gone crazy" while the macro is running.