If you run a macro to clear shapes from the worksheet, it will also
remove the data validation dropdown. Could that be the problem?

LA wrote:
Hi all,
I am experiencing a problem with data validation. Validation cell still
works but the dropdown list does not appear. When I copy that cell to another
cell in the same worsheet, the same problem still occurs but to other
worksheet, it works normally.
FYI, valadated cell is not part of frozen part of the worksheet and in-cell
dropdown is selected.
Pls help to solve this problem.
Tks and rgds,
LA


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html