XL97: Stop Recording Button Is Not Displayed During Macro Record

Last reviewed: March 19, 1998
Article ID: Q174612
The information in this article applies to:
  • Microsoft Excel 97 for Windows

SYMPTOMS In Microsoft Excel 97, if you close the Stop Recording toolbar while recording a macro, the next time you Start Recording you will not get the Stop Recording toolbar.

RESOLUTION

If the Stop Recording toolbar does not appear when you begin recording a macro, you must display it while recording so that it will appear in the future. To display the Stop Recording toolbar, follow these steps as your last steps while recording your macro:

  1. On the View menu, point to Toolbars, and then click Stop Recording.

    The Stop Recording toolbar appears.

  2. Perform any additional actions you want to be recorded in the macro.

  3. On the Stop Recording toolbar, click the Stop Recording button.

  4. On the Tools menu, point to Macro, and then click Macros.

  5. Click the macro name that was just recorded, and click Edit.

  6. Delete the following line from the macro:

          Application.CommandBars("Stop Recording").Visible = True
    

NOTE: This line was recorded by displaying Stop Recording toolbar in step 3 and must be deleted.

REFERENCES

For more information about recording macros, click the Index tab in Microsoft Excel Help, type the following text

   macros, recording

and then double-click the selected text to go to the "Record a macro" topic.


Additional query words: XL97 stop button record
Keywords : kbprg
Version : WINDOWS:97
Platform : WINDOWS
Issue type : kbprb


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: March 19, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.