slt, en reponse a ta question je pense que j'ai quelque code en VBA qui pour creer une barre de menu.
Voici le code.
Public Sub CreerMenu()
Dim Cmb As Office.CommandBar
Dim btn As Office.CommandBarButton
Dim SubCmb As Office.CommandBarPopup
Dim SubCmb1 As Office.CommandBarPopup
On Error Resume Next
Application.CommandBars("MaBarre" ).Delete
Set Cmb = Application.CommandBars.Add("MaBarre", msoBarTop, True, False)
Set SubCmb = Cmb.Controls.Add(msoControlPopup)
SubCmb.Caption = "Saisie"
Set btn = SubCmb.Controls.Add(msoControlButton)
With btn
.Caption = "Ecole"
.Style = msoButtonCaption
.OnAction = "Saisie Ecole"
End With
Set btn = SubCmb.Controls.Add(msoControlButton)
With btn
.Caption = "Année Scolaire"
.Style = msoButtonCaption
Public Sub CreerMenu()
Dim Cmb As Office.CommandBar
Dim btn As Office.CommandBarButton
Dim SubCmb As Office.CommandBarPopup
Dim SubCmb1 As Office.CommandBarPopup
On Error Resume Next
Application.CommandBars("MaBarre" ).Delete
Set Cmb = Application.CommandBars.Add("MaBarre", msoBarTop, True, False)
Set SubCmb = Cmb.Controls.Add(msoControlPopup)
SubCmb.Caption = "Saisie"
Set btn = SubCmb.Controls.Add(msoControlButton)
With btn
.Caption = "Ecole"
.Style = msoButtonCaption
.OnAction = "Saisie Ecole"
End With
Set btn = SubCmb.Controls.Add(msoControlButton)
With btn
.Caption = "Année Scolaire"
.Style = msoButtonCaption
.OnAction = "a propos"
End With
Cmb.Visible = True
End Sub
---------------
Indi yatt6ara