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- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to permanently delete a custom toolbar
Hi 39N95W (nice name)
You can find your answer in this article and a lot more http://support.microsoft.com/default...02&Product=xlw How to customize menus and menu bars in Excel -- Regards Ron de Bruin http://www.rondebruin.nl "39N95W" wrote in message ... 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- |
Reply |
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 |