Consulting

Results 1 to 4 of 4

Thread: Excel 2007 Removing a Custom Tab and Ribbon

  1. #1
    VBAX Expert
    Joined
    May 2006
    Location
    Oklahoma City, OK
    Posts
    532
    Location

    Excel 2007 Removing a Custom Tab and Ribbon

    Good evening to everyone in VBA Express. I read Ken Pul's article on his web site about how to add a custom tab and group to the Excel 2007 ribbon http://excelguru.ca/blog/2006/11/20/...art-1-of-many/ . I used the Microsoft Office 2007 Custom UI Editor to make a new tab and group as Ken explained and it works well. My question is if you no longer need or just want to remove the Custom UI tab and group from the Excel 2007 ribbon how do you do this?

    Best regards,

    Charlie
    Best regards,

    Charlie

    I need all the I can get....

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    You just update your XML to remove the code for the custom tab, or clear the XML altogether.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    VBAX Expert
    Joined
    May 2006
    Location
    Oklahoma City, OK
    Posts
    532
    Location
    Hello XLD how are you today. I'm going to show a lot of ignorance here, but where is the XML located?
    Best regards,

    Charlie

    I need all the I can get....

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Get hold of a copy of the CustomUYI editor, open the xlsm file in there, and you will see it all

    http://openxmldeveloper.org/articles...muieditor.aspx
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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