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
|
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
Dim Liste_codes(1 To 10), Liste_Actions(1 To 10) As String
Liste_codes(1) = "Code 1" ' Ce sont les items qui apparissent dans le menu
Liste_codes(2) = "Code 2"
Liste_codes(3) = "Code 3"
'etc...
Liste_Actions(1) = "code1" ' le nom de la macro a lancer
Liste_Actions(2) = "code2"
Liste_Actions(3) = "code3"
'etc...
For Each icbc In Application.CommandBars("cell").Controls
If Left(icbc.Tag, 5) = "brccm" Then icbc.Delete
Next icbc
For Each icbc In Application.CommandBars("cell").Controls
If icbc.Tag = "brccm" Then icbc.Delete
Next icbc
For i = 1 To 3
With Application.CommandBars("Cell").Controls _
.Add(Type:=msoControlButton, before:=1, temporary:=True)
.Caption = Liste_codes(i)
.OnAction = Liste_Actions(i)
.Tag = "brccm" + Str(i)
End With
Next i
End Sub |
Partager