Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
Data Validation and Freezing Panes questionPosted 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.
Re: Data Validation and Freezing Panes questionPosted by Ivan F Moala on January 02, 2002 8:42 PM
This is a problem with Excel97...problem resolved
in latter versions...........
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store
to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.