XL98: Stop Recording Button Is Not Displayed Recording a Macro

ID: Q182872


The information in this article applies to:
  • Microsoft Excel 98 Macintosh Edition


SYMPTOMS

In Microsoft Excel 98, if you close the Stop Recording toolbar while you are recording a macro, the next time you start recording, the Stop Recording toolbar does not appear.


WORKAROUND

If the Stop Recording toolbar does not appear when you begin recording a macro, display it (as the last steps) while you record the macro. To display the Stop Recording toolbar while you record the macro, follow these steps:

  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 record 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 you recorded and click Edit.


  6. Delete the following line from the macro:


  7. 
    Application.CommandBars("Stop Recording").Visible = True 
NOTE: This line is recorded when you display the Stop Recording toolbar in step 3 and must be deleted.


REFERENCES

For more information about recording macros, click Contents and Index on the Help menu (or on the Balloon Help menu if you are using a version of the Macintosh operating system earlier than 8.0), click the Index button in Excel Help, type the following text

macros, recording
and then click Show Topics. Select the "Record a macro" topic, and click Go To. If you are unable to find the information you need, ask the Office Assistant.

Additional query words: XL98 stop button record

Keywords : kbdta xltoolbar xlmac
Version : MACINTOSH:98
Platform : MACINTOSH
Issue type : kbprb


Last Reviewed: November 4, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.