Excel 2007: Blank Visual Basic Alerts when running

Symptoms

Receive a blank Visual Basic alert dialog when running VBA macros

Cause

Excel application is busy when Ribbon controls try to initialize.

Resolution

Client Machine: 
  1. Click OK on the prompts, the number of prompts depends on the add-in.
Developer Machine:
  1. Move the code out of the workbook to a com add-in or Visual Studio Tools for Office
  2. Introduce delays in VBA code, such as, Application.Ontime to mitigate the conflict
Properties

Article ID: 2405428 - Last Review: Sep 9, 2010 - Revision: 1

Feedback