XL98: No "Record at Mark" Feature in Microsoft Excel (182412)


The information in this article applies to:

  • Microsoft Excel 98 Macintosh Edition
This article was previously published under Q182412
For a Microsoft Excel 2000 version of this article, see 213571.
For a Microsoft Excel 97 version of this article, see 157958.

SYMPTOMS

You cannot record a Visual Basic for Applications macro within another macro in Microsoft Excel 98 Macintosh Edition. This feature is available in earlier versions of Microsoft Excel.

CAUSE

Because of the major changes made to the Visual Basic for Applications environment in Microsoft Excel 98 Macintosh Edition, this functionality is no longer available.

WORKAROUND

If you need to record a Visual Basic for Applications macro within another macro, follow these steps:

  1. Record your macro.
  2. Start the Visual Basic Editor by pressing OPTION+F11.
  3. Select the code in your newly recorded macro, copy it, and paste it into your existing macro.

MORE INFORMATION

The following menu items are available in earlier versions of Microsoft Excel. 
   Menu    Menu item      Submenu
   --------------------------------------------------
   Tools   Record Macro   Mark Position For Recording
   Tools   Record Macro   Record At Mark
In earlier versions of Microsoft Excel, you can use these menu items to record a Visual Basic for Applications macro within another macro.

For additional information, please see the following article in the Microsoft Knowledge Base:

108060 XL: Recording a Visual Basic Macro in an External Module

These menu items, and the functionality they provide, are not available in Microsoft Excel 98 Macintosh Edition. To circumvent this limitation, use the steps shown in the "Workaround" section of this article.
Modification Type:MajorLast Reviewed:9/11/2002
Keywords:kbprb kbProgramming KB182412
©2002 Microsoft Corporation. All rights reserved.