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

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 Bruin
http://www.rondebruin.nl/tips.htm


"mcarbon1" wrote in message ...
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

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?

"mcarbon1" wrote:

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

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" wrote in message
...
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

On Oct 16, 2:41*pm, "Ron de Bruin" wrote:
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



"mcarbon1" wrote in ...
I frequently debug Excel 2007 add-ins. Once I load anadd-in, it, of
course shows up on the RibbonAdd-Intab.

After I'm done, I unload theadd-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- Hide quoted text -

- Show quoted text -

Hi Rob -

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

Mark

On Oct 16, 2:45*pm, "Charles Williams"
wrote:
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

"mcarbon1" wrote in message

...



I frequently debug Excel 2007 add-ins. Once I load anadd-in, it, of
course shows up on the RibbonAdd-Intab.

After I'm done, I unload theadd-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- Hide quoted text -

- Show quoted text -

Hi Charles -

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

Mark

On Oct 16, 2:45*pm, ~L wrote:
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?



"mcarbon1" wrote:
I frequently debug Excel 2007 add-ins. Once I load anadd-in, it, of
course shows up on the RibbonAdd-Intab.

After I'm done, I unload theadd-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- Hide quoted text -

- 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