The information in this article applies to:
SYMPTOMSIn Microsoft Excel version 7.0, when you use the Microsoft Excel 4.0 macro language ADD.COMMAND function, if you use menu item names for the position argument, this function may fail, and you may receive the following error message:
CAUSEThe Excel 4.0 Macro language ADD.COMMAND function fails if you use non- existent menu item names for the position argument. Microsoft Excel 7.0 menus are different from menus in previous versions of Microsoft Excel. RESOLUTION
To work around this problem, you can prevent the ADD.COMMAND function from
failing by doing either of the following:
-or- STATUSMicrosoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available. MORE INFORMATION
Microsoft provides macro examples for illustration only, without warranty
either expressed or implied, including but not limited to the implied
warranties of merchantability and/or fitness for a particular purpose.
This macro is provided 'as is' and Microsoft does not guarantee that the
following code can be used in all situations. Microsoft does not support
modifications of the code to suit customer requirements for a particular
purpose.
To make the macro code work, use a number for the position argument, as in
the following example:
REFERENCES"Microsoft Excel Function Reference," version 4.0, page 8 Additional query words:
Keywords : xlwin |
Last Reviewed: October 19, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |