custom toolbar options
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 27

Thread: custom toolbar options
Thanks Thanks: 0 Likes Likes: 0

  1. #11
    Board Regular
    Join Date
    Apr 2003
    Location
    United KIngdom
    Posts
    126
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: custom toolbar options

    I'll stick with excel for a while. Enough confusion here but thanks to you guys life is somewhat less painful

    ishi

  2. #12
    Board Regular
    Join Date
    Apr 2003
    Location
    United KIngdom
    Posts
    126
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: custom toolbar options

    just another question is it possible to change the background colour of the custom toolbars from the rather boring grey.

    Thanks,

    ishi

  3. #13
    MrExcel MVP TommyGun's Avatar
    Join Date
    Dec 2002
    Location
    Clear Lake, TX
    Posts
    4,202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: custom toolbar options

    Nope (at least not in XL 97). This is set by your Windows color schemes.

  4. #14
    Board Regular
    Join Date
    Apr 2003
    Location
    United KIngdom
    Posts
    126
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: custom toolbar options

    i am using xl2000

  5. #15
    MrExcel MVP TommyGun's Avatar
    Join Date
    Dec 2002
    Location
    Clear Lake, TX
    Posts
    4,202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: custom toolbar options

    Don't have that here, or I would check, but I don't think you can do that with 2000 either.

  6. #16
    Board Regular
    Join Date
    Apr 2003
    Location
    United KIngdom
    Posts
    126
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: custom toolbar options

    I have somewhat got hang of the toolbar apart from being able to have many buttons under one button (if that makes sense). For example in excel under file you have new-open-close all under file. This is what i am trying to create but not very successfully.

    another suggestion please.

    ishi

  7. #17
    MrExcel MVP TommyGun's Avatar
    Join Date
    Dec 2002
    Location
    Clear Lake, TX
    Posts
    4,202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: custom toolbar options

    If you are trying to create a "menu" on a toolbar, then you have to use the PopUp control and then add controls to it.

    Sub CreateToolbar()
    Dim TB As CommandBar
    Dim MyMenu As CommandBarPopup
    Dim MyMenuItem As CommandBarButton

    Set TB = Application.CommandBars.Add(Name:="TestThis")
    Set MyMenu = TB.Controls.Add(Type:=msoControlPopup)
    Set MyMenuItem = MyMenu.Controls.Add(Type:=msoControlButton)

    MyMenu.Caption = "Test Menu"

    MyMenuItem.Caption = "Test Menu Item"

    TB.Visible = True

    Set MyMenuItem = Nothing
    Set MyMenu = Nothing
    Set TB = Nothing
    End Sub

  8. #18
    Board Regular
    Join Date
    Apr 2003
    Location
    United KIngdom
    Posts
    126
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: custom toolbar options

    thanks tommygun, but i think i have what i am looking for. When you go to view-toolbars-customize and create a new one then under command the middle tab you can select New Menu at the bottom and this way i can have different sections under a menu. Hope this makes sense.

    Although i guess the referencing will be different.

    ishi

  9. #19
    MrExcel MVP TommyGun's Avatar
    Join Date
    Dec 2002
    Location
    Clear Lake, TX
    Posts
    4,202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: custom toolbar options

    You could do the same with the above code. It was just posted as an example of how to do it programatically. See this link for more information...http://j-walk.com/ss/excel/tips/tip53.htm

  10. #20
    Board Regular
    Join Date
    Apr 2003
    Location
    United KIngdom
    Posts
    126
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: custom toolbar options

    thanks will check it out.

    ishi

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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