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