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


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.


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.


This is a known issue in Excel 2013.

Id. de artículo: 2796730 - Última revisión: 6 ene. 2013 - Revisión: 1