Excel 2013 UI disappears until the VBA code in a macro is completed

Article translations Article translations
Article ID: 2796730 - View products that this article applies to.
Expand all | Collapse all

On This Page

Symptoms

Assume that you run a macro that adds a new worksheet or scrolls the view to a location that is outside the current screen range in an Excel 2013 workbook. However, the user interface (UI) in Excel 2013 disappears. This issue continues until the Visual Basic for Applications (VBA) code in the macro is completed.

Note When this issue occurs the whole screen that displays the Excel 2013 UI may flicker.

Workaround

To work around this issue, use one of following methods:
  • Use the DoEvents function in the Visual Basic for Applications (VBA) code when you create the macro.
  • Disable hardware acceleration in Excel 2013. To do this, follow these steps:
    1. Click Options on the FILE tab.
    2. Click Advanced in the Excel Options dialog box.
    3. Select the Disable hardware graphics acceleration check box in the Display section.
    4. Click OK in the Excel Options dialog box.

Status

This is a known issue in Excel 2013.

Properties

Article ID: 2796730 - Last Review: January 6, 2013 - Revision: 4.0
Applies to
  • Microsoft Excel 2013
Keywords: 
kbprb kbsurveynew kbexpertiseinter kbtshoot KB2796730

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com