1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
|
Private Sub CreateItemMenuWmb()
Dim PMnu As Object
DeleteItemMenuWmb
Set PMnu = CommandBars(cWmb).Controls.Add(Type:=msoControlPopup, Before:=8)
With PMnu
.Caption = "Mode Edition"
End With
With CommandBars(cWmb).Controls("Affichage")
.Controls.Add(Type:=msoControlButton).Caption = cM52
.Controls(cM52).OnAction = "MenuClick"
.Controls(cM52).Tag = "52"
End With
With CommandBars(cWmb).Controls(cM2)
.Controls.Add(Type:=msoControlButton).Caption = cM53
.Controls(cM53).OnAction = "MenuClick"
.Controls(cM53).Tag = "53"
End With
Set PMnu = Nothing
End Sub
Private Sub MenuClick
Select Case CommandBars.ActionControl.Tag
'Réponse au evenements...
End Select
End sub |
Partager