Is there a way I can extend the view of my drop down list (validation list)
so that a scroll bar does not appear? I have a list of 12 items, but only 7
can be viewed; the viewer has to scroll down to see the remaining five items
in the list. Is there a way to force Excel to display all 12 items without a
scroll bar? I can do it by using the drop down from the control toolbox
(vba), but I'm using a simple validation list (Data--Validation).
Thanks,
Exceller