Ron, I'm sorry, you kind of lost me with your code. Do I input this code in
the cell? I appreciate your help!

"Ron Coderre" wrote:

Try something like this Workbook_Open event code:

Private Sub Workbook_Open()
With Sheet1.Range("B2")
.Select
Application.SendKeys ("%{DOWN}")
End With
End Sub

Is that something you can work with?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

"bethjoy79" wrote in message
...
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