ID: Q183846
The information in this article applies to:
When data on a worksheet is changed, a Microsoft Visual Basic for Applications Change event macro that you created does not run.
This problem occurs when the following conditions are true:
-and-
-or-
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.
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.
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:
ARTICLE-ID: Q179216
TITLE : OFF98: How to Use the Microsoft Office Installer Program
Additional query words: XL98
Keywords : kbprg kbdta kbdtacode OffVBA
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbbug
Solution Type : kbpending
Last Reviewed: April 15, 1998