Remove a custom toolbar from Excel 2007 Add in ribbon?

9tanstaafl9

Well-known Member
Joined
Mar 23, 2008
Messages
534
I had tried to creat a custom toolbar (manually, not using VBA) for an Excel 2003 report. I have long since deleted the toolbar and gone to selecting my macros via right-click, but for some reason the toolbar still appears for people who are using my report in Excel 2007. I've seen this myself so I know they aren't crazy. Unfortunately, the toolbar doesn't work. How do delete it? I'm not overly familiar with Excel 2007.

I tried going to the Add-ins manager, but there is no reference to my toolbar there. I tried going back to my report in Excel 2003 and File/View/Toolbars/Customize so I could delete the toolbar, but again it isn't there for my report specifically or Excel in general.

I'm stumped. Any suggestions?

Also, I just moved the report to a clean computer that never ran it before, and the toolbar is there too.
 
Last edited:

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Geoff Taylor

Active Member
Joined
Dec 11, 2006
Messages
257
I'm bumping this thread because I have a very similar problem.

My personal.xls had a couple of toolbars that contained lots of custom icon buttons which I'd select from when assigning macros. In 2007 they're pretty much redundant but they appear in the Add-Ons section and I could really do with getting rid of them.
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
35,397
Office Version
365, 2019, 2016, 2010
Platform
Windows, MacOS

ADVERTISEMENT

FWIW, to remove them if you have 2003, you can choose View-Toolbars,Customize..., switch to the Toolbars tab, press the Attach button, and then remove them from the right hand list.
 

9tanstaafl9

Well-known Member
Joined
Mar 23, 2008
Messages
534
CommandBars have .Builtin property and a .Delete method - see http://msdn.microsoft.com/en-us/library/aa214205(office.11).aspx

Any use?

Thank you so much, and this solves the problem for the version of my report that was still in the old version of Excel. Unfortunately, I had made significant modifications since I was forced to upgrade to 2007 and all those versions have the stupid toolbar/addin.

It appears only in the Addin portion of the Ribbon. It does not appear at all if you go to the Add In Manager, so I can't deselect it. Does anybody have any suggestion as to how I could be rid of this?

Once anyobody loads my report even once, the Add In remains on their computer, even if they aren't using the report. I don't even have the original code that created the menu any more, so I don't know how I made this monstrosity. I had thought it was a straight non vba menu created, but now I'm starting to wonder... All I want to do is kill it from the ribbon, or make it appear in the manager so I an deselect it. God I hate the ribbon.
 

9tanstaafl9

Well-known Member
Joined
Mar 23, 2008
Messages
534
FWIW, to remove them if you have 2003, you can choose View-Toolbars,Customize..., switch to the Toolbars tab, press the Attach button, and then remove them from the right hand list.

Just an FYI for anyone else who is reading this, I had tried the above step originally and it didn't work by itself. It would seem to work and then the toolbar would reappear. What finally did the trick was when I deleted my personal.xls and restarted along with doing the step above. And note that I had to it both from the report itself, and from Excel when the report was not open. Then I restarted the computer. And I emptied my trash just for good measure. (I'm not claiming to be an expert, just reporting my experience for anyone else suffering from this frustrating experience.)

But then when I opened the report in Excel 2007, the toolbar appeared in the ribbon. So I didn't win. But at least it was gone from 2003.
 

Subscribe on YouTube

Watch MrExcel Video

Forum statistics

Threads
1,106,506
Messages
5,511,706
Members
408,862
Latest member
sidneybc

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top