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-
|