Private Sub Workbook_Open()
Dim i As Byte, c As Range
For i = 1 To 9
With Sheets("Recherche").OLEObjects("ComboBox" & i)
Set c = .Parent.Range(.LinkedCell) 'cellule liée
.Top = c.Top
.Left = c.Left
.Height = c.Height
.Width = c.Resize(, 6).Width
End With
Next
Me.Saved = True 'évite l'invite à la fermeture si aucune modification
End Sub