XL97: No "Record at Mark" Feature in Microsoft Excel 97Last reviewed: March 13, 1998Article ID: Q157958 |
The information in this article applies to:
SYMPTOMSYou cannot record a Visual Basic macro "inside" another macro in Microsoft Excel 97. This feature is available in earlier versions of Microsoft Excel.
CAUSEBecause of the major changes made to the Visual Basic environment in Microsoft Excel 97, this functionality is no longer available.
WORKAROUNDIf you need to record a Visual Basic macro "inside" another macro, record your macro in the normal manner. Once recording is complete, you can activate Visual Basic Editor by pressing ALT+F11 on the keyboard. Then, select the code in your newly-recorded macro, copy it, and paste it into your existing macro.
STATUSThis behavior is by design of Microsoft Excel 97.
MORE INFORMATIONThe 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 MarkIn earlier versions of Microsoft Excel, you can use these menu items to record a Visual Basic macro "inside" another macro. For example, assume you have the following macro in a Visual Basic module:
Sub Test() MsgBox "This is a test macro." End SubIf you want to add more code to the "Test" macro, but you want to record the additional code, do the following:
These menu items, and the functionality they provide, are not available in Microsoft Excel 97. Use the workaround shown earlier in this article to circumvent this limitation.
|
Additional query words: XL97 8.00 vbe
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |