Sub supprime_C_Shapes()
Dim nombre As Integer
Dim Ws As Worksheet
nombre = ActiveWorkbook.Sheets.Count
Application.ScreenUpdating = False
For I = 1 To nombre
Worksheets(I).Unprotect Password:="blabla"
Next I
Application.ScreenUpdating = False
AfficherOnglets
Dim Forme As Object
For Each Ws In Sheets
For Each Forme In Ws.Shapes
With Forme
Select Case .Type
Case 12
'ici permet de ne pas supprimer
'les boutons de la BO Formulaire
Case Else
'supprime le reste
.Delete
End Select
End With
Next Forme
Next Ws
End Sub