Sub Workbook_Open()
Dim liste, i As Byte, obj As OLEObject
'Chargement de tous les ComboBox dont le préfixe est "ComboPPA"
liste = Array("Ordre Alphabétique", "Famille")
For i = 1 To 7
Set obj = ActiveSheet.OLEObjects("ComboPPA" & i).Object
With Worksheets("Données").obj
.List = liste
.ListIndex = 0
End With
Next
End Sub