Freeze panes

[Jason]

I'm working on an Excel spreadsheet which includes a number of drop down
lists. When I select freeze panes to prevent horizontal and vertical
movement the drop down list optins is no longer available. Is there a
solution/work around available?

 

[Dave Peterson]

You're still using xl97????

This bug/feature was fixed in xl2k.

The workaround is to remove the freeze panes.

 

[Gord Dibben]

Or make sure the dropdowns are below the Freeze line.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Or don't use Data|Validation.

Maybe use a dropdown from the Forms toolbar or a combobox from the control
toolbox toolbar.