XL97: Macro Recorder Doesn't Record Some Menu CommandsLast reviewed: March 13, 1998Article ID: Q159223 |
The information in this article applies to:
SYMPTOMSWhen you click a menu command while recording a Visual Basic for Applications macro, Microsoft Excel does not record the macro code for the menu command you clicked. When you run the recorded macro, it may not perform as expected.
CAUSEThis problem occurs if while recording a macro, you click a menu command that was added to a menu by an add-in file included with Microsoft Excel 97. For example, when you click Save As HTML on the File menu while recording a macro, the recorded macro does not contain code to run the macro assigned to the Save As HTML command. Microsoft Excel does not record the code because the menu command was added by the Html.xla add-in file.
RESOLUTIONIf you are creating a macro that executes code assigned to a menu command, you must manually edit the macro and add the appropriate code. Code assigned to a menu will be assigned using the OnAction property in Microsoft Visual Basic for Applications. For additional information, please see the following article in the Microsoft Knowledge Base:
ARTICLE-ID: Q162040 TITLE : XL97: Sample Macros to Customize or Replace a Menu BarNote that some of the affected menu commands use their own commands; for example, the Solver add-in contains commands that you can add to your macro when you want to set up and execute the Solver. Note: Add-in macros cannot be edited as they are protected and hidden.
STATUSThis behavior is by design in Microsoft Excel 97.
MORE INFORMATIONWhen you record a Visual Basic for Applications macro, Microsoft Excel 97 does not record the following menu commands.
Menu Command Submenu command ----- -------------------- --------------- Tools AutoSave Tools Data Analysis Tools Look Up Reference Tools Solver Tools Wizards Conditional Sum Tools Wizards File Conversion Tools Wizards Lookup Tools Wizards Web Form File Save As HTML Data Convert to MS Access Data MS Access Form Data MS Access Report Data Template WizardMicrosoft Excel 97 records the following menu commands.
Menu Command ---- -------------- View Custom Views View Report Manager |
Additional query words: XL97
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |