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
Thuộc tính

ID Bài viết: 2405428 - Xem lại Lần cuối: 09-09-2010 - Bản sửa đổi: 1

Phản hồi