ID: Q182240
The information in this article applies to:
When 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.
This 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 98 Macintosh Edition. 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 Internet Assistant Wizard add-in file.
If 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.
Note 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.
This behavior is by design in Microsoft Excel 98 Macintosh Edition.
When you record a Visual Basic for Applications macro, Microsoft Excel 98 Macintosh Edition does not record the following menu commands.
Menu Command Submenu command
----------------------------------------------
Tools AutoSave
Tools Data Analysis
Tools Solver
Tools Wizard Conditional Sum
Tools Wizard File Conversion
Tools Wizard Lookup
File Save As HTML
Data Template Wizard
Menu Command
---------------------
View Custom Views
View Report Manager
Keywords : kbmacro kbdta xlvbahowto xlvbainfo OffVBA xladdins
Platform : MACINTOSH
Issue type : kbprbLast Reviewed: February 13, 1999