You can't, that's the way it is. But you could always make the DV cell
distinct via eg creative formatting. Eg: using dark red fill with bold white
font for the DV cell, with a text phrase "Select" in the cell just above the
DV, or use a bold arrow, or a call-out autoshape to point to the DV cell, etc
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bethjoy79" wrote:
I used validation to create a drop down list, but my question is how to make
that drop down appear when I open the worksheet instead of just clicking on
the cell?

Thanks,
Beth