Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with OLEObjects
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OLEObjects | Excel Programming | |||
OLEObjects .. again | Excel Programming | |||
Problem activating OLEObjects | Excel Programming | |||
Taking over OLEObjects... Possible ?! | Excel Programming | |||
OLEObjects clickable? | Excel Programming |