Article ID: 157958
Article Last Modified on 10/10/2006
APPLIES TO
- Microsoft Excel 97 Standard Edition
This article was previously published under Q157958
For a Microsoft Excel 2000 version of this article, see 213571.
For a Microsoft Excel 98 Macintosh Edition version of this article, see 182412.
SYMPTOMS
You cannot record a Visual Basic for Applications macro within another macro in Microsoft Excel 97. 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 97, this functionality is no longer available.
WORKAROUND
If you want to record a Visual Basic for Applications macro within another macro, follow these steps:
- Record your macro.
- Start the Visual Basic Editor by pressing ALT+F11.
- 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 97. To circumvent this limitation, use the steps shown in the "Workaround" section of this article.
Additional query words: XL97 vbe
Keywords: kbfaq kbprb kbprogramming KB157958
