Microsoft KB Archive/182240

= XL98: Macro Recorder Doesn't Record Some Menu Commands =

Article ID: 182240

Article Last Modified on 6/12/2007

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q182240





SYMPTOMS
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.



CAUSE
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.



RESOLUTION
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.



STATUS
This behavior is by design in Microsoft Excel 98 Macintosh Edition.



MORE INFORMATION
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 Microsoft Excel 98 Macintosh Edition records the following menu commands.   Menu   Command -  View   Custom Views View  Report Manager

Additional query words: XL98

Keywords: kbmacro kbprb KB182240

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.