Hi,

My code:
For Each objOLE In Sheet1.OLEObjects
If objOLE.progID = "Forms.ComboBox.1" Then
With .OLEObjects(objOLE.Name).Object
.Enabled = False
.Clear
.value = ""
End With
End If
Next

For some reason, when I checked the Properties Enable, they remain as True.
But, they are grey out. And this cause problem to a commandbutton which would
initilise this combobox, since they remain grey out.

Thanks