I also momentarily turn screen updating on and then off again to show each sheet as it processes.Much better than staring at an unchanging screen for 40 seconds (that would be like watching the microwave for 40 seconds -- it takes forever).Thus, the main body of your macro can do its work behind the scenes without the necessity of stopping to update the screen.is your source for cost-effective Microsoft Word training.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.Many people write their own macros to manipulate the information in a workbook.Many people write their own macros to manipulate their documents.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.
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.
Try it both ways; you should see a clear difference between the two ways of running the test.
With the checkbox set, the underlying code disables screen updates, so you shouldn't see the reports' icons pop up.
You can find a version of this tip for the older menu interface of Excel 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.