View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
39N95W[_2_] 39N95W[_2_] is offline
external usenet poster
 
Posts: 3
Default How to permanently delete a custom toolbar

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-