XL97: Stop Recording Button Is Not Displayed During Macro Record

• 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
   

REFERENCES

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

   macros, recording