How to permanently delete a custom toolbar

[39N95W]

Windows XP
Excel 2002 & 2003

Back when I was first learning VBA I made my own custom toolbar and added a
few buttons to it. It was created via right clicking on an existing toolbar
and choosing Customize..., not programmatically. The buttons didn't
actually do anything though. Anyway, it seems I have unknowingly spread
this toolbar around the office. How would I permanently delete this
innocuous little monster? I tried the code below and it didn't work, but it
didn't give an error either:

Sub MyCleanup()

dim cbar as CommandBar

For Each cbar In CommandBars
If cbar.Name = "MyBar" Then
cbar.delete
MsgBox "Toolbar ""MyBar"" deleted."
Exit Sub
End If
Next cbar

MsgBox "Toolbar ""MyBar"" not found."

Exit Sub


Any help greatly appreciated!

-gk-

 

[Ron de Bruin]

Hi 39N95W (nice name)

You can find your answer in this article and a lot more

http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw
How to customize menus and menu bars in Excel