The idea is to use the first line near the beginning of your macro, and then use the second line near the end.
Thus, the main body of your macro can do its work behind the scenes without the necessity of stopping to update the screen.
He is president of Sharon Parq Associates, a computer and publishing services company. Check out I've written several macro programs that take a while to execute. For example, one program I alone use takes about 40 seconds to execute across 12 similar sheets.
In that case, I update the status bar message every time the code starts on the next sheet.
Allen Wyatt With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. John Walkenbach's name is synonymous with excellence in deciphering complex technical topics. Spreadsheet" shows how to maximize your Excel experience using professional spreadsheet application development tips from his own personal bookshelf. Tell the user what's going on and provide an indication of progress, ideally every three to ten seconds.One thing you may want to do with your macro to make it run faster and to prevent distracting flashes on the screen is to turn off screen updating while the macro is running.The following macro lines will, respectively, turn off screen updating and then turn it back on in a VBA macro.You can verify this by launching Word the old-fashioned way and opening File1 at the bottom of the File menu after running the sample code.Although it would be difficult to do an exhaustive test, in theory this should work from any Automation client-Visual Basic, Excel, Power Point, or any other.I say this because if I run the code from the VB Editor and put a break on any line in Make Slide From Visio Page(), and then press F5 each time through, the code runs successfully.