Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
permanently delete toolbar | Excel Discussion (Misc queries) | |||
How do I permanently delete a custom toolbar in Excel? | Excel Worksheet Functions | |||
Can't delete custom button and toolbar | Excel Programming | |||
How to permanently delete a custom toolbar? | Excel Programming | |||
delete custom toolbar | Excel Programming |