How to get rid of macro leftovers in Excel?

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

Posted 2014-05-13T09:51:10.097

Reputation: 9 376

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.

– Raystafarian – 2014-05-13T12:49:08.043

Here is the MS KB on ribbon xml, I'd look there to find the default and reactivate it. – Raystafarian – 2014-05-13T12:51:05.330

1Please check if you have any hidden workbooks (like Personal.xlsb) opened: View tab -> Window group -> Unhide. – Alex Frolov – 2014-05-13T14:29:42.250

@AlexFrolov I didn't even consider the fact that it may be calling from the personal macro workbook. +1 – Raystafarian – 2014-05-13T19:34:51.267

1My 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 – 2014-05-14T06:45:07.253

@AlexFrolov – the control is disabled. I have edited the question to make it more complete. Thanks. – miroxlav – 2014-05-14T09:06:23.140

@Raystafarian – let me try this a bit later and then come back with feedback. – miroxlav – 2014-05-14T13:16:36.220

Answers

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

Posted 2014-05-13T09:51:10.097

Reputation: 9 376

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

user348815

Posted 2014-05-13T09:51:10.097

Reputation:

Asked: 2014-05-13T09:51:10.097

Viewed: 1 386 times

Active: 2014-07-29T21:43:54.797