I think Dave meant,... "or remove the freeze panes"
You could use WindowSplit instead
Dave Peterson wrote:
Are you using windows|freeze panes?
Is your cell with Data|validation above that line?
If yes, move the cell or remove the data|validation.
It's a bug in xl97, fixed in xl2k.
Patrick Gibbons wrote:
This is in a MS Office 97 Excel Workbook, although I have selected data
validation for a cell the in-cell dropdown is not showing up. Of course
some silly person would tell me that I don't have the In-cell Dropdown
checkbox selected . . . got it smart guy. It is still not working.
I will give you the current setup:
Cell L4 has the current data validation:
Allow: List
Source: =$B$54:$B$65
Ignore blank - selected
In-cell Dropdown - selected
Cells B54:B65
January
February
March . . . etc.
Anyone have any ideas?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html