hide all comboboxes
 

Hi

i would like to hide all comboboxes on a particular sheet without knowing
all their names

is this possible?

Thanks

hide all comboboxes
 

Option Explicit
Sub testme()
Dim OLEObj As OLEObject
For Each OLEObj In ActiveSheet.OLEObjects
If TypeOf OLEObj.Object Is MSForms.ComboBox Then
OLEObj.Visible = False
End If
Next OLEObj
End Sub




sunilpatel wrote:

Hi

i would like to hide all comboboxes on a particular sheet without knowing
all their names

is this possible?

Thanks

--

Dave Peterson