View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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