A
Al
Hi there
A while back, someone sent me the useful code below. It adds macros to the
Right-Click menu in excel and is great. However, I can't figure out how to
remove items from the menu once they've been added. Could anyone help with
this ?? My Right-Click menu is getting scarily big.... thanks!!
Sub AddItemToContextMenu()
Dim cmdNew As CommandBarButton
Set cmdNew = CommandBars("cell").Controls.Add
With cmdNew
.Caption = "MACRO TITLE HERE"
.OnAction = "MACRO NAME HERE"
.BeginGroup = True
End With
End Sub
A while back, someone sent me the useful code below. It adds macros to the
Right-Click menu in excel and is great. However, I can't figure out how to
remove items from the menu once they've been added. Could anyone help with
this ?? My Right-Click menu is getting scarily big.... thanks!!
Sub AddItemToContextMenu()
Dim cmdNew As CommandBarButton
Set cmdNew = CommandBars("cell").Controls.Add
With cmdNew
.Caption = "MACRO TITLE HERE"
.OnAction = "MACRO NAME HERE"
.BeginGroup = True
End With
End Sub