Disable Option in Como Box
No.
--
Regards,
Tom Ogilvy
"ExcelMonkey" wrote in message
...
I have a combo box with two items in it. Is it possible to load both
items
but restric access to only one of them. For examle below you can see that
I
have two items. I want the user to see both but I want to disable access
to
the second one. That is I want the user to know the option will be there
evenutally but now now. What I am really asking is does the item have an
enabled property? Thanks
With MainUserForm.DisplayResultsCmbBx
.AddItem "As New Worksheet in This Excel File"
.AddItem "As Worksheet in New Excel File"
End With
|