Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete Custom VBA Menu
I have created a VBA menu using the following code and now want to remove the
menu but can't. Any ideas on how to remove the menu and to make it go away when I close the particular file it is attached to? Jeff Sub AddNewMenu() Dim oCB As CommandBar Set oCB = Application.CommandBars("Worksheet Menu Bar") Dim newMenu As CommandBarControl Set newMenu = oCB.Controls.Add(Type:=10) With newMenu .Caption = "Transit Manager" .Enabled = True With .Controls.Add(Type:=msoControlButton) .Caption = "Start . . ." .FaceId = 39 .OnAction = "Start_New_Process" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Import LE's" .FaceId = 938 .OnAction = "macro2" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Import Actuals" .FaceId = 988 .OnAction = "macro3" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Print Reduced" .FaceId = 707 .OnAction = "macro2" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Button5" .FaceId = 29 .OnAction = "macro1" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Finish . . ." .FaceId = 41 .OnAction = "macro2" End With End With End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete Custom VBA Menu
Application.CommandBars("Worksheet Menu Bar").Controls("Tranist
Manager").Delete -- HTH Bob Phillips "Jeff" wrote in message ... I have created a VBA menu using the following code and now want to remove the menu but can't. Any ideas on how to remove the menu and to make it go away when I close the particular file it is attached to? Jeff Sub AddNewMenu() Dim oCB As CommandBar Set oCB = Application.CommandBars("Worksheet Menu Bar") Dim newMenu As CommandBarControl Set newMenu = oCB.Controls.Add(Type:=10) With newMenu .Caption = "Transit Manager" .Enabled = True With .Controls.Add(Type:=msoControlButton) .Caption = "Start . . ." .FaceId = 39 .OnAction = "Start_New_Process" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Import LE's" .FaceId = 938 .OnAction = "macro2" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Import Actuals" .FaceId = 988 .OnAction = "macro3" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Print Reduced" .FaceId = 707 .OnAction = "macro2" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Button5" .FaceId = 29 .OnAction = "macro1" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Finish . . ." .FaceId = 41 .OnAction = "macro2" End With End With End Sub |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to delete Custom VBA Menu
Thanks Bob, worked like a charm
JEff "Bob Phillips" wrote: Application.CommandBars("Worksheet Menu Bar").Controls("Tranist Manager").Delete -- HTH Bob Phillips "Jeff" wrote in message ... I have created a VBA menu using the following code and now want to remove the menu but can't. Any ideas on how to remove the menu and to make it go away when I close the particular file it is attached to? Jeff Sub AddNewMenu() Dim oCB As CommandBar Set oCB = Application.CommandBars("Worksheet Menu Bar") Dim newMenu As CommandBarControl Set newMenu = oCB.Controls.Add(Type:=10) With newMenu .Caption = "Transit Manager" .Enabled = True With .Controls.Add(Type:=msoControlButton) .Caption = "Start . . ." .FaceId = 39 .OnAction = "Start_New_Process" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Import LE's" .FaceId = 938 .OnAction = "macro2" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Import Actuals" .FaceId = 988 .OnAction = "macro3" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Print Reduced" .FaceId = 707 .OnAction = "macro2" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Button5" .FaceId = 29 .OnAction = "macro1" End With With .Controls.Add(Type:=msoControlButton) .Caption = "Finish . . ." .FaceId = 41 .OnAction = "macro2" End With End With End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete custom menu bars | Setting up and Configuration of Excel | |||
VBA - Disappearing custom menu and custom toolbar | Excel Programming | |||
Custom Menu | Excel Programming | |||
Custom Menu return to Excel Menu upon Closing | Excel Programming | |||
Custom Menu | Excel Programming |