How To Remove Add-in Icons From the 2007 Ribbon

[mcarbon1]

I frequently debug Excel 2007 add-ins. Once I load an add-in, it, of
course shows up on the Ribbon Add-In tab.

After I'm done, I unload the add-in, clean up in the Add-n Manager,
delete the .XLA file, etc., but the damned icons still stay in the
ribbon. I'm building up a large collection of unused, unlinked, good-
for-nothing icons in the Ribbon.

Is there ANY way to get rid of them?

I've tried creating a new PERSONAL.XLSB file, with no addins, but that
doesn't seem to work.

Any help would be greatly appreciated!

Mark

 

[Ron de Bruin]

Hi Mark

Delete your xlb file

1) Close Excel
2) Do a search for .xlb in Windows (Use: search hidden files and folders)
3) Rename or delete the .xlb file or files (In 2007 the name = Excel12.xlb)
4) Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you. (You lost your customization remember that)
If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it)

 

[~L]

I only have the analysis toolpack and unselecting it from the manager removes
the ribbon group for me, so I don't know if it will work, but did you install
and have you tried the Office Diagnostic tool?

 

[Charles Williams]

Your addins should delete the toolbars they create in their Workbook_Close
event, then you won't have this problem.

Probably you can get rid of the existing icons by deleting your Excel12.xlb,
although I have not tried this.

regards
Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

 

[mcarbon1]

Hi Mark

Delete your xlb file

1) Close Excel
2) Do a search for .xlb in Windows (Use: search hidden files and folders)
3) Rename or delete the .xlb file or files (In 2007 the name = Excel12.xlb)
4) Start Excel

Deleting the file or renaming will do no harm to your system
Excel will create a new file for you. (You lost your customization remember that)
If you make your own toolbars or add buttons to the others
this file is important (backup it so you can restore it)

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm










- Show quoted text -

Hi Rob -

Deleting Excel12.xlb solved the problem. Thank you VERY much for your
help!

Mark

 

[mcarbon1]

Your addins should delete the toolbars they create in their Workbook_Close
event, then you won't have this problem.

Probably you can get rid of the existing icons by deleting your Excel12.xlb,
although I have not tried this.

regards
Charles
__________________________________________________
The Excel Calculation Sitehttp://www.decisionmodels.com











- Show quoted text -

Hi Charles -

Deleting Excel12.xlb solved the problem. Thanks VERY much for your
help!

Mark

 

[mcarbon1]

I only have the analysis toolpack and unselecting it from the manager removes
the ribbon group for me, so I don't know if it will work, but did you install
and have you tried the Office Diagnostic tool?










- Show quoted text -

Thanks for your suggestion. I found that deleting the hidden file
Excel12.xlb solved the problem. The icons went away, and the next time
I closed Excel, I had a fresh copy of Excel12.xlb, minus the problem.

Mark