- Repeatedly select cells
- Insert sheets
- Update or opens task panes
- Add a workbook
- Use ScreenUpdating to disable the screen updates of Excel so you do not see the changes while they are disabled. This also may improve your macro performance.
Application.ScreenUpdating = False
Application.ScreenUpdating = True
- If you need to see the screen changes, insert a DoEvents command after the line in the code that causes the screen to appear white. Using DoEvents sparingly will help maintain macro performance.
Note: For all versions of Excel, a similar effect can occur in long running macros when Windows turns the application white and marks it not responding. This occurs because Excel is not responding to Windows while the macro is running. DoEvents will also assist in this scenario by allowing Excel to respond to Windows and allow the application screen to recover.
Article ID: 2790615 - Last Review: Feb 1, 2013 - Revision: 1