Notice: Undefined offset: 2 in /home2/icentarb/public_html/icentar/classes/class.permissions.php on line 735
Sub CreateContextMenu() Dim cbr As CommandBar Dim cbb As CommandBarButton ' Delete the command bar if it already exists DeleteContextMenu ' Create a new command bar of type msoBarPopup Set cbr = CommandBars.Add(Name:="MyBar", Position:=msoBarPopup) With cbr ' Add first item Set cbb = .Controls.Add(type:=msoControlButton) With cbb .Caption = "Item 1" .Style = msoButtonCaption .OnAction = "MyFunc1" End With ' Add second item Set cbb = .Controls.Add(type:=msoControlButton) With cbb .Caption = "Item 2" .Style = msoButtonCaption .OnAction = "MyFunc2" End With ' Add third item Set cbb = .Controls.Add(type:=msoControlButton) With cbb .Caption = "Item 3" .Style = msoButtonCaption .OnAction = "MyFunc3" End With ' Add fourth item Set cbb = .Controls.Add(type:=msoControlButton) With cbb .Caption = "Item 4" .Style = msoButtonCaption .OnAction = "MyFunc4" End With End With End Sub ' Delete the shortcut menu Sub DeleteContextMenu() On Error Resume Next CommandBars("MyBar").Delete End Sub ' These functions are executed by the shortcut menu items Function MyFunc1() MsgBox "This is MyFunc1", vbInformation End Function Function MyFunc2() MsgBox "This is MyFunc2", vbInformation End Function Function