MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Data Validation and Freezing Panes question


Posted by hansoh on January 02, 2002 11:38 AM

i have a problem with Data Validation when i Freeze Panes.

if i use ListBoxes via Data Validation and Freeze Panes, the listbox will not dropdown. however, if i UnFreeze Panes, the listbox will dropdown.

how can i resolve this issue? thanks in advance.


han


Posted by Ivan F Moala on January 02, 2002 8:42 PM

This is a problem with Excel97...problem resolved
in latter versions...........


Ivan