The information in this article applies to:
SYMPTOMSYou cannot record a Microsoft Visual Basic for Applications macro within another macro in Microsoft Excel. This feature is available in versions of Microsoft Excel earlier than Excel 97. CAUSEBecause 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:
MORE INFORMATION
The following menu items are available in versions of Microsoft
Excel earlier than Excel 97.
In versions of Microsoft Excel earlier than Excel 97, you can use these menu items to record a Visual Basic for Applications macro within another macro. These menu items, and the functionality they provide, are not available in Microsoft Excel 97 or later. To circumvent this limitation, use the steps shown in the "Workaround" section of this article. REFERENCES
For additional information about this behavior in earlier versions of Microsoft Excel, please see the following article in the Microsoft Knowledge Base: Q108060 XL: Recording a Visual Basic Macro in an External Module Additional query words: vbe XL2000
Keywords : kbprg kbdta xlui KbVBA |
Last Reviewed: July 6, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |