Data Validation Dropdown

J

jliu2000

I don't see the dropdown list on one worksheet. if I copy the cell an
paste special Validation to another worksheet, then the dropdown lis
shows.

Tools/options/show All checked. tried restart PC also.

the trouble (dropdown list doesn't show even though Data validatio
object is OK) happens only to one worksheet in this one workbook.

any one interested to see the workbook with the troubled worksheet ca
drop me an email.

thanks al
 
G

Gord Dibben

Send it on down.

Change the obvious in my munged email address to email me.

Gord Dibben Excel MVP
 
Top