Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Apr 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Macro recording button (Excel 2000)

    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

  2. #2
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Kortrijk, Belgium
    Posts
    571
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro recording button (Excel 2000)

    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.

  3. #3
    New Lounger
    Join Date
    Apr 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro recording button (Excel 2000)

    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.

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Macro recording button (Excel 2000)

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

    Andrew C

  5. #5
    New Lounger
    Join Date
    Apr 2002
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro recording button (Excel 2000)

    Absolutely perfect. Thank you!

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Macro recording button (Excel 2000)

    Alternatively, just start recording a macro, rightclick a toolbar and select stop recording.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •