The information in this article applies to:
SUMMARYYou may have a macro that uses the ON.DATA() function, but your macro halts every time it encounters this function. Even if you troubleshoot this line, this error may keep appearing. Check to ensure that you are disabling the ON.DATA() function before you make any changes to it. (Note: this is also true for version 5.0 macro sheets, but not modules.) MORE INFORMATION
The ON.DATA(document_text,macro_text) function starts the macro
specified by macro_text whenever another application sends new data to
the document specified by document_text. Once called, the ON.DATA()
function remains in effect until you turn it off (by calling ON.DATA()
without the macro_text argument, or by turning off Excel).
SolutionCreate a simple two-line macro using ON.DATA(document_text) and Return() in a separate area on the macro sheet and run this new macro between each test of the original macro.Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 4.0 5.0
Keywords : |
Last Reviewed: March 21, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |