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 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66
| Sub BuildControls()
Dim oPopUp As CommandBarPopup
Dim oCtr As CommandBarControl
Dim oSubMenu As CommandBarPopup
' Supprimer tous les contrôles du menu contextuel standard
On Error Resume Next
For Each oCtr In CommandBars("Text").Controls
oCtr.Delete
Next oCtr
On Error GoTo 0
' Ajouter le menu personnalisé en haut du menu Text
Set oPopUp = CommandBars("Text").Controls.Add(msoControlPopup, , , 1)
With oPopUp
.Caption = "My Very Own Menu"
.Tag = "custPopup"
.BeginGroup = True
End With
' Ajouter les macros personnalisées au menu personnalisé
With oPopUp.Controls.Add(msoControlButton)
.Caption = "Option 1"
.OnAction = "InsererTexteOption1"
End With
' Ajouter l'option 2 avec un sous-menu contenant deux macros
Set oSubMenu = oPopUp.Controls.Add(msoControlPopup)
With oSubMenu
.Caption = "Option 2"
' Ajouter la première macro du sous-menu
With .Controls.Add(msoControlButton)
.Caption = "Macro 1"
.OnAction = "MacroOption2_1"
End With
' Ajouter la deuxième macro du sous-menu
With .Controls.Add(msoControlButton)
.Caption = "Macro 2"
.OnAction = "MacroOption2_2"
End With
End With
With oPopUp.Controls.Add(msoControlButton)
.Caption = "Option 3"
.OnAction = "InsererTexteOption3"
End With
' Ajouter les macros Attention, Vigilance et Coopération
With oPopUp.Controls.Add(msoControlButton)
.Caption = "Attention"
.OnAction = "AttentionMacro"
End With
With oPopUp.Controls.Add(msoControlButton)
.Caption = "Vigilance"
.OnAction = "VigilanceMacro"
End With
With oPopUp.Controls.Add(msoControlButton)
.Caption = "Coopération"
.OnAction = "CooperationMacro"
End With
End Sub |
Partager