Macro recording button (Excel 2000)

Topic

New Reply

Hi.
I occasionally record macros. While recording, a box comes up with a button to stop recording, and a button to toggle between relative and absolute cell references. Clumsily, I’ve just closed the box with the little x in the top right corner, and now when I record macros it doesn’t come up any more. How do I get it back? Thanks.
Ed Lycett

Reply | Quote

Replies

go to View >> Toolbars >> Customize then select the Toolbars tab in the dialog box and check the box next to stop recording. If you now click the little x in the top corner, the record macro toolbar disappears but will reappear next time you want to record a macro.

Reply | Quote

I’ve tried selecting the “stop recording” toolbar in but then the button is either always there or never there, regardless of whether I’m in macro recording mode. It used to appear in macro recording mode then disappear when the stop button was pushed, and it’s this behaviour I’ve managed to break.

Reply | Quote

Try Tools, Customize, Toolbars, select the Stop recording and then click on reset. That should restore the default setting.

Andrew C

Reply | Quote

Absolutely perfect. Thank you!

Reply | Quote

Alternatively, just start recording a macro, rightclick a toolbar and select stop recording.

Reply | Quote