Use of the ON.DATA() Command in ExcelLast reviewed: November 2, 1994 |
SUMMARYWhen using the ON.DATA() command in Excel, you need to verify the following:
MORE INFORMATION
You may NOT reference any particular cells. The following would NOT be valid: =ON.DATA("Sheet1.xls!$A$1","Macro1.xlm!R1C1") =ON.DATA("Sheet1.xls!Area1","Macro1.xlm!Macro_name") The ON.DATA() command is used in Excel when you want a particular macro to run any time there is any type of update to a particular worksheet via DDE. The format of the formula is =ON.DATA("Document_Text","Macro_text"). If executed properly, the macro defined by Macro_text will run every time there is a DDE update to the worksheet specified by Document_Text. |
KBCategory: kbother Last reviewed: November 2, 1994 |