+ Reply to Thread
Results 1 to 6 of 6

Mix up of buttons in Excel Add-In ribbon - how to delete buttons?

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    Schweiz
    MS-Off Ver
    Excel 2010
    Posts
    4

    Mix up of buttons in Excel Add-In ribbon - how to delete buttons?

    Hi,

    a few years ago, I wrote an add-in for Excel 2003. Later I had someone convert it for 2010. All was well, until I recently opened an old xls that contains code to load a command bar. All those old buttons now made a mess of my add-in ribbon.
    How can that be fixed? I understand that there should be an xml somewhere, where buttons are defined. But which file is it?

    Thank you!

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Mix up of buttons in Excel Add-In ribbon - how to delete buttons?

    just right-click them in the ribbon and remove them
    Josie

    if at first you don't succeed try doing it the way your wife told you to

  3. #3
    Registered User
    Join Date
    01-11-2013
    Location
    Schweiz
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Mix up of buttons in Excel Add-In ribbon - how to delete buttons?

    Thank you! That was simple. Took me more than an hour of searching and browsing forums etc.
    I was not able to delete individual buttons, though, but only complete command bars. With a warning that this cannot be undone. I was afraid that it would remove *everything* including the buttons that I wanted to keep.

    Still, would you know how to find the xml that defines my add-in buttons? It must be an xml. I know how to create new ones with Custom UI. But I don't know how to find old ones ...

  4. #4
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Mix up of buttons in Excel Add-In ribbon - how to delete buttons?

    it's probably in
    c:\users\username\appdata\local\microsoft\office\excel.officeui

  5. #5
    Registered User
    Join Date
    01-11-2013
    Location
    Schweiz
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Mix up of buttons in Excel Add-In ribbon - how to delete buttons?

    Thanks again. That file contains code to show the AddIn tab, but not the actual buttons. I spent more time trying to find the button definitions, to no avail.

  6. #6
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: Mix up of buttons in Excel Add-In ribbon - how to delete buttons?

    they may be in an .xlb file then as they were in older versions

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1