Thanks Paul, but I'm not using Freeze panes at all.

Anyone else?

" wrote:

On Jan 30, 2:46 pm, Dr. Schwartz
wrote:
In Excel 2003 I have a specific sheet where the validation list does not
appear (arrow button gone) when set. I can set it up (Data/Validation menu)
as usual with out problems. The other sheets in the workbook do not have this
problem.

I don't know if this has anything to do with the phenomenon, but I have
recently run this macro in the sheet:

Dim shp As Shape
For Each shp In ActiveSheet.Shapes
shp.Delete
Next

Can anyone help me get my validation lists back?

Thanks
The Doctor

Hi
May be a mile off, but is your validation above a Freeze Panes line?
Seem to remember validation not working above a Freeze Pane, at least
in earlier Excel versions..
Paul