software

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

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 :-)
------------------------------*------------------------------*----------------quot;Stan Lawsonquot; lt;Stan gt; wrote in message
...
gt;I have used data validation with list and have set the in-cell drop down.
gt; But I have lost the drop down arrow. This is just on one worksheet in the
gt; workbook of several worksheets and all of the others the incell drop down
gt; works fine. and I can copy the cell from the one worksheet to others and
gt; it
gt; works. Some how I must have turned off the drop down function, but I
gt; don't
gt; how
We have come across this before, but no-one seems to know a way of getting
it back. AFAIK you will have to rebuild your worksheet.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

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