Excel 97: "Freeze Panes" disables data validation? 1

[VBAjedi]

Hi all!

In an Excel 97 spreadsheet I'm building, I have used freeze panes between columns "C" and "D" to keep an index section in columns A:C visible. Column "C" is supposed to have in-cell data validation with a drop-down list, but it seems to be disabled because it borders the freeze-line.

Are there any workarounds to this besides moving the freeze-line or moving the data?

Thanks!
VBAjedi

 

[DaleWatson123321]

I've confirmed that the same problem still exists with Excel 2000.

However, I do have the following "workaround" for you...

While the drop-down-arrow does not appear, the Data Validation can still be activated by...
Holding down the <Alt> key and hitting the <Down-Arrow>

Hope this helps.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[Wray69]

Your workaround is alot better than Microsoft's is Dale;

WORKAROUND
To work around this problem, unfreeze the window panes. To unfreeze panes, click Unfreeze Panes on the Window menu.

XL97: Data Validation List Does Not Appear (236620)

Not much of a workaround at all... heh

Regards -

Wray