PDA

View Full Version : Excel 2007 Removing a Custom Tab and Ribbon



coliervile
01-19-2009, 03:44 PM
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/modifying-the-ribbon-part-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

Bob Phillips
01-19-2009, 04:12 PM
You just update your XML to remove the code for the custom tab, or clear the XML altogether.

coliervile
01-19-2009, 04:28 PM
Hello XLD how are you today. I'm going to show a lot of ignorance here, but where is the XML located?

Bob Phillips
01-19-2009, 06:11 PM
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/customuieditor.aspx