XL98: Worksheet Change Event Macro Fails to Run (183846)
The information in this article applies to:
- Microsoft Excel 98 Macintosh Edition
This article was previously published under Q183846 SYMPTOMS
When data on a worksheet is changed, a Microsoft Visual Basic for
Applications Change event macro that you created does not run.
CAUSE
This problem occurs when the following conditions are true:
- You create a Change event macro that is associated with a worksheet.
-and-
- You paste data in the worksheet from the clipboard instead of typing it.
-or-
- You create a dynamic data exchange (DDE) link from another program to
the worksheet.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
MORE INFORMATION
You can create a Visual Basic event macro that runs whenever the data on a
worksheet is changed. The Change event macro runs when data is added or
updated on the worksheet. However, when you paste data from another program
or update data by using a DDE link, the Change event does not occur.
REFERENCES
For more information about using a Change Event, click the Office
Assistant, type change event click Search, and then click to view "Change
Event."
NOTE: If the Assistant is hidden, click the Office Assistant button on the
Standard toolbar. If Microsoft Help is not installed on your computer,
please see the following article in the Microsoft Knowledge Base:
179216 OFF98: How to Use the Microsoft Office Installer Program
| Modification Type: | Major | Last Reviewed: | 9/11/2002 |
|---|
| Keywords: | kbbug kbdtacode kbProgramming KB183846 |
|---|
|