Private Sub Workbook_Open()
Dim Iconeimpression As CommandBarButton
On Error Resume Next
Set Iconeimpression = Application.CommandBars('Standard').Controls('My Impression')
'Creer un nouveau bouton IconeImpression seulement s'il n'existe pas déjà !
If Iconeimpression Is Nothing Then
Set Iconeimpression = Application.CommandBars('standard').Controls.Add _
(Type:=msoControlButton, before:=6, Temporary:=True)
With Iconeimpression
.Caption = 'My impression'
.FaceId = 160
.Style = msoButtonIconAndCaption
.OnAction = 'tutu'
End With
End If
End Sub
Private Sub Workbook_BeforeClose(Cancel As Boolean)
On Error Resume Next
Application.CommandBars('Standard').Controls('My Impression').Delete
End Sub