Sub Affiche_Images() Dim numLig As Integer Dim numCol As Integer Dim numImage As Long Dim Menu1 As CommandBar Dim Button1 As CommandBarControl ' Crée une barre d'outils temporaire Set Menu1 = Application.CommandBars.Add _ (Position:=msoBarFloating, temporary:=True) ' Ajoute un bouton de commandes Set Button1 = Menu1.Controls.Add(msoControlButton) ' Modifie l'image du bouton de commandes ' et la recopie dans une cellule Excel For numCol = 1 To 10 Step 2 For numLig = 1 To 100 numImage = numImage + 1 Button1.FaceId = numImage Button1.CopyFace ActiveSheet.Cells(numLig, numCol) = numImage ActiveSheet.Paste Cells(numLig, numCol + 1) Next numLig Next numCol ' Redimensionne les colonnes Columns("A:W").Select Selection.ColumnWidth = 4 ' Supprime la barre d'outils Menu1.Delete End Sub Sub Efface_Images() Dim m_Shape As Shape ' Supprime les images et les numéros For Each m_Shape In ActiveSheet.Shapes If m_Shape.Type = msoPicture Then m_Shape.Select Selection.Delete End If Range("A1:I100").Select Selection.ClearContents Next End Sub