Article ID: 157958 - Last Review: October 10, 2006 - Revision: 1.2 XL97: No "Record at Mark" Feature in Microsoft ExcelThis article was previously published under Q157958 For a Microsoft Excel 2000 version of this article, see 213571
(http://support.microsoft.com/kb/213571/EN-US/
)
.
For a Microsoft Excel 98 Macintosh Edition version of this article, see 182412 (http://support.microsoft.com/kb/182412/EN-US/ ) . 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:
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 For additional information, please see the following article in the Microsoft Knowledge Base: 108060
(http://support.microsoft.com/kb/108060/EN-US/
)
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.
| Article Translations
|
| United States | Change | | | All Microsoft Sites |
Back to the top
|
