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?

miroxlav
  • 14,845

2 Answers2

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.

miroxlav
  • 14,845