XL98: Worksheet Change Event Macro Fails to Run

• Microsoft Excel 98 Macintosh Edition

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:

Q179216 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