If you hit data / Validation does it still show it as being linked to a
list.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Stan Lawson" <Stan wrote in message
...
I have used data validation with list and have set the in-cell drop down.
But I have lost the drop down arrow. This is just on one worksheet in the
workbook of several worksheets and all of the others the incell drop down
works fine. and I can copy the cell from the one worksheet to others and
it
works. Some how I must have turned off the drop down function, but I
don't
how