3

Old macro workbook from Microsoft samples gallery left items on the ADD-INS ribbon tab, highlighted by yellow:

enter image description here

These cannot be deleted or at least I don't know where to find them – see Customize Ribbon window open on the screenshot – they are not there.

Items are bound to still functional macros, but I can't find their code. There is nothing in top-left pane (which shows list of VBA modules) in VBA IDE.

I have checked all Addin types in Excel Options > Add-ins, they are not there.
I have checked Add-ins and COM Add-ins items on ribbon's DEVELOPER tab, these do not contain it.
I have checked Addin Manager in VBA IDE, it is empty.
I checked for hidden workbooks in View tab (thanks @AlexFrolov) and Unhide button is disabled.
The only list I did not check was list of Automation Servers due to its length (it can be opened using Add-ins window).

ADD-INS ribbon tab is missing only in Excel Safe mode but unwanted icons are always present in standard mode.

How can I delete this toolbar labeled "Custom toolbar" from ADD-INS ribbon tab?

7
  • Sounds like an add-in customized the ribbon UI, which is done via xml. see info in this SO thread. Given I've never used this feature of excel, I can't think of how to help. Look up on how to reset the xml that powers the ribbon UI. May 13, 2014 at 12:49
  • Here is the MS KB on ribbon xml, I'd look there to find the default and reactivate it. May 13, 2014 at 12:51
  • 1
    Please check if you have any hidden workbooks (like Personal.xlsb) opened: View tab -> Window group -> Unhide. May 13, 2014 at 14:29
  • @AlexFrolov I didn't even consider the fact that it may be calling from the personal macro workbook. +1 May 13, 2014 at 19:34
  • 1
    My best guess is a ribbonui element that has stored itself in the default template. Open a different template and see if the ribbon is still there. If not, find the default template file and delete the XML by unzipping the file and searching for it.
    – wbeard52
    May 14, 2014 at 6:45

2 Answers 2

0

@ miroxlav: Still looking for an answer? You could try the following:

  • in your highlighted ribbon > right-click on one of the symbols (to make sure you hit the custom toolbar) > within the context-menu choose "Delete custom menu" (wording may be slightly different, am using a German Excel here).

Hope that helps! Mike

0

The customizations disappeared due to unknown reason. To make sure everything is all right I pressed Reset button (also visible on the image in the question above). Now the problem is gone.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .