How I make the dropdown list as readonly
Posted by Pooja on November 30, 2000 6:22 PM
I have created a pull down menu for cell thru a VBA
Now I want to make that pulldown.....just readonly.
THe user can just see the options but he shouldn't
not be allowed to select any options.
How do I need to do that?
Please help me as soon as possible.
I have used..Selection.validation object.
But please tell me the various other properties
to be set to achieve this