Excel 2007 Ribbon - Remove unwanted custom toolbars

  • Thread starter Thread starter Muscoby
  • Start date Start date
M

Muscoby

We had a series of engineering worksheets created in earlier versions of
Excel that utilized custom toolbars created solely for the worksheets. they
would be attached to the files which is how they were distributed to guys out
in the field.
Now that we are in the Office 2007 realm, our custom toolbars have been
inserted into the Excel ribbon when our worksheets were opened.
We have rewritten our engineering sheets to work with Excel 2007. Our
problem is we cannot get rid of the many custom toolbars that have been
populated on our Add Ins tab when Excel 2007 is opened on our machines.
There are no references to our files in the Excel options menu. Our original
files have been completely deleted and removed. No files or original
worksheets exist on our systems or network.
How can we get rid of these useless legacy toolbars populating our AddIns tab?
If we are to use the CustomUI Editor, what file do we open that represents
Excel in general and not a specific file?
 
hi, !

when you open a file (created in xl-97/2003) with attached custom commandbars
xl-2007 (re)creates those custom commandbars in a file named: excel12.xb
(in a <hidden ?> folder, i.e. c:\documents and settings\<user>\program data\microsoft\excel\excel12.xlb)

from there, every time you open excel, the addins {tab in ribbon} will be there
(even if you delete the original file with the custom commandbars attached)
until you delete this file from your hard drive

(BTW, I think this is the "best way" to transport the traditional 97-2003 menu-bars to xl-2007)

regarding the CustomUI Editor, visit Ron de Bruin's website:
http://www.rondebruin.nl/tips.htm (section: Excel 2007 Ribbon and QAT pages)

hth,
hector.

__ OP __
 
Back
Top