the drop down list of data validation disappeared from one of the worksheet.
no more drop down list appear for new data validation.
it happens on one worksheet only. I suspect the worksheet is somehow
corrupt. it works fine on other tabs. how do I get the drop down list again?

If you are referring to the arrow icon, I don't think you can, you will need
to rebuild it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ping" wrote in message
...
the drop down list of data validation disappeared from one of the
worksheet.
no more drop down list appear for new data validation.
it happens on one worksheet only. I suspect the worksheet is somehow
corrupt. it works fine on other tabs. how do I get the drop down list
again?

Hi

Ctrl-A (two times to select all cells
Ctrl-C to copy
Insert Worksheet
Ctrl-v to paste in A1 of the new sheet

Have you used code to delete shapes ??




--
Regards Ron de Bruin
http://www.rondebruin.nl



"Bob Phillips" wrote in message ...
If you are referring to the arrow icon, I don't think you can, you will need
to rebuild it.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ping" wrote in message
...
the drop down list of data validation disappeared from one of the
worksheet.
no more drop down list appear for new data validation.
it happens on one worksheet only. I suspect the worksheet is somehow
corrupt. it works fine on other tabs. how do I get the drop down list
again?