Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Jan 2007
    Posts
    123
    Thanks
    13
    Thanked 1 Time in 1 Post

    Recording Macro toolbar's Relative mode button ? (Excel 2003 / Windows XP)

    Normally while I record a macro, I can see a small floating toolbar with two buttons: one to stop recording, and another to toggle between relative and absolute recording modes. I've accidentally clicked the X on the upper right hand corner of this toolbar, making it disappear. Now I can't seem to get it back, despite looking under Toolbars and through the Customise menu. How can I get it back? Without it I can't toggle between relative and absolute modes.

    I'd be grateful for any help.

  2. #2
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Recording Macro toolbar's Relative mode button ? (Excel 2003 / Windows

    I don't have 2003 anymore, but if I recall correctly, try this:

    Start a new recording, then while you are recording a macro right click on any toolbar. In the shortcut menu you will see the "Stop Recording" toolbar listed. Click on it to recover it. Stop the 'dummy' macro and delete it. The toolbar should be available again.
    Regards,
    Rudi

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Recording Macro toolbar's Relative mode button

    You can also choose View-Toolbars-Customize and check the Stop Recording toolbar there.
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    2 Star Lounger
    Join Date
    Jan 2007
    Posts
    123
    Thanks
    13
    Thanked 1 Time in 1 Post

    Re: Recording Macro toolbar's Relative mode button

    Thanks to both of you!

  5. #5
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='rory' post='689464' date='20-Jan-2008 22:54']You can also choose View-Toolbars-Customize and check the Stop Recording toolbar there.[/quote]

    This was the advice I've just given to someone who had the same problem as the OP.

    However, is that the only way of getting at that button? Does it not exist as a menu entry or option or a tick box somewhere else within XL or the VBE?

    Ken

  6. #6
    5 Star Lounger
    Join Date
    Aug 2004
    Location
    Connecticut, USA
    Posts
    816
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='stuck' post='766409' date='20-Mar-2009 11:24']However, is that the only way of getting at that button? Does it not exist as a menu entry or option or a tick box somewhere else within XL or the VBE?[/quote]

    The "Stop Recording" will only appear on the Customization menu when a macro is being recorded.
    You could add the Visual Basic toolbar to have a play or record (or stop while recording) button close at hand. You could also run the following in the immediate window of VBA to make the toolbar appear - drag it to reside with your other tool bars to make it "permanent"

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

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    [quote name='stuck' post='766409' date='20-Mar-2009 16:24']This was the advice I've just given to someone who had the same problem as the OP.

    However, is that the only way of getting at that button? Does it not exist as a menu entry or option or a tick box somewhere else within XL or the VBE?

    Ken[/quote]
    No other way as far as I know...

  8. #8
    5 Star Lounger
    Join Date
    Apr 2001
    Location
    Arriving Somewhere but not Here
    Posts
    698
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='766412' date='20-Mar-2009 15:59']No other way as far as I know...[/quote]

    End of story then!

    I'm reassured that it wasn't just me that couldn't find it because it was staring me in the face

    Thanks,

    Ken

Posting Permissions

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