Greetings,
I have a workbook with 19 worksheets in it. On one of them, the In-Cell
Dropdown for validation doesn't appear. It works fine on the other 18
sheets. If I set up validation on a "good" sheet and copy/paste
special/validation onto the "bad" sheet, I don't get a dropdown. If I set up
validation on the "bad" sheet and copy/paste special/validation onto a "good"
sheet, it works fine on the good sheet.
It's like there's a "show in-cell dropdown" property on the worksheet that's
set to "false." If I try to type invalid data into the cell, I get the
validation error message, so I know the validation is there. The "In-Cell
dropdown" checkbox is checked. When I go to "goto/special/validation" the
cell highlights. Just no dropdown.
Any thoughts?

Thanks.
--
Mike Lee
McKinney,TX USA