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