Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Aug 2002
    Location
    Denmark
    Posts
    347
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Add custom toolbar name to 'customize' menu (Win XP SP2 - XL2003 UK)

    Hi,

    Got a custom toolbar that can be selected from Tools -addins menu.
    However it is not shown in the 'Tools' - 'Customize' - 'Toolbars' list of available and checkable toolbars.

    My question is - what do I have to do to have my custom toolbar displayed in the list...?

    THX!
    Bests,
    RD


    PS: Wish there were a knob on the TV to turn up the intelligence. There's a knob called "brightness," but that doesn't work

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Add custom toolbar name to 'customize' menu (Win XP SP2 - XL2003 UK)

    When you drag the custom ToolBar down from the Toolbar area onto the Worksheet area the Toolbar's name will appear in the Title area of the toolbar. Are you certain this name (not the caption) does not appear near the bottom of the list?
    Regards
    Don

  3. #3
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add custom toolbar name to 'customize' menu (Win XP SP2 - XL2003 UK)

    Maybe the custom toolbar is "protected". Don't know much about Excel, but in Word it's possible to hide a toolbar from the list in Tools - Customize - Toolbars, with one line of VBA code:

    ActiveDocument.Commandbars("MyBar").Protection = msoBarNoChangeVisible

    To make it visible again, just use:

    ActiveDocument.Commandbars("MyBar").Protection = msoBarNoProtection

    I wouldn't be surprised if something like this is possible in Excel.

  4. #4
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Add custom toolbar name to 'customize' menu (Win XP SP2 - XL2003 UK)

    Hi Jan
    In Excel it's exactly as you described.
    Regards
    Don

  5. #5
    4 Star Lounger
    Join Date
    Dec 2003
    Location
    Zoetermeer, Zuid-Holland, Netherlands
    Posts
    559
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Add custom toolbar name to 'customize' menu (Win XP SP2 - XL2003 UK)

    Thanks for the confirmation Don.

Posting Permissions

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