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

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" <(E-Mail Removed)> wrote in message
news:39736EAE-5B37-4527-B8C5-(E-Mail Removed)...
>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

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

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" <(E-Mail Removed)> wrote in message
> news:39736EAE-5B37-4527-B8C5-(E-Mail Removed)...
> >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
>
>
>

Ooops! Sorry for being vague..

Heres what you do:

Right-click on the sheet tab and select: View Code
(that will open the Visual Basic Editor and display the code module for the
sheet.)

The left side of the VBE will list the workbook and all of its sheets.
Double-click on the "This Workbook" item
(that will display the code module for the workbook)

Copy the below code and paste it into that window (changing the sheet name
and cell reference):

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

Then...Save the workbook.....Close it......then re-open it.

Does that help?

--------------------------

Regards,

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



"bethjoy79" <(E-Mail Removed)> wrote in message
news:13451359-7B25-49D4-826F-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
>> news:39736EAE-5B37-4527-B8C5-(E-Mail Removed)...
>> >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
>>
>>
>>

Ron,
Thanks for the clarification.
I did copy and paste the formula into the View Code, changing the name of
the sheet and cell, but it didn't change anything. I have three sheets in
the workbook and I changed it both in the "This Workbook" and "Sheet 2." Did
I do something wrong?
I have a spreadsheet that someone sent me that has what I'm looking for, but
the sheet is locked , so I know it can be done, I just can't figure it out.
UGH?!!

Beth

"Ron Coderre" wrote:

> Ooops! Sorry for being vague..
>
> Heres what you do:
>
> Right-click on the sheet tab and select: View Code
> (that will open the Visual Basic Editor and display the code module for the
> sheet.)
>
> The left side of the VBE will list the workbook and all of its sheets.
> Double-click on the "This Workbook" item
> (that will display the code module for the workbook)
>
> Copy the below code and paste it into that window (changing the sheet name
> and cell reference):
>
> Private Sub Workbook_Open()
> Sheets("Sheet1").Activate
> Range("B2").Select
> Application.SendKeys ("%{DOWN}")
> End Sub
>
> Then...Save the workbook.....Close it......then re-open it.
>
> Does that help?
>
> --------------------------
>
> Regards,
>
> Ron (XL2003, Win XP)
> Microsoft MVP (Excel)
>
>
>
> "bethjoy79" <(E-Mail Removed)> wrote in message
> news:13451359-7B25-49D4-826F-(E-Mail Removed)...
> > 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" <(E-Mail Removed)> wrote in message
> >> news:39736EAE-5B37-4527-B8C5-(E-Mail Removed)...
> >> >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
> >>
> >>
> >>
>
>
>

Can you post:
the name of the workbook,
the name of the worksheet,
and the reference to the cell with the DV drop-down list
that you want displayed upon opening the workbook?

Also post the code you're using.

We'll see what we can to to help you.
--------------------------

Regards,

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



"bethjoy79" <(E-Mail Removed)> wrote in message
news:08941042-2D52-442F-9BE0-(E-Mail Removed)...
> Ron,
> Thanks for the clarification.
> I did copy and paste the formula into the View Code, changing the name of
> the sheet and cell, but it didn't change anything. I have three sheets in
> the workbook and I changed it both in the "This Workbook" and "Sheet 2."
> Did
> I do something wrong?
> I have a spreadsheet that someone sent me that has what I'm looking for,
> but
> the sheet is locked , so I know it can be done, I just can't figure it
> out.
> UGH?!!
>
> Beth
>
> "Ron Coderre" wrote:
>
>> Ooops! Sorry for being vague..
>>
>> Heres what you do:
>>
>> Right-click on the sheet tab and select: View Code
>> (that will open the Visual Basic Editor and display the code module for
>> the
>> sheet.)
>>
>> The left side of the VBE will list the workbook and all of its sheets.
>> Double-click on the "This Workbook" item
>> (that will display the code module for the workbook)
>>
>> Copy the below code and paste it into that window (changing the sheet
>> name
>> and cell reference):
>>
>> Private Sub Workbook_Open()
>> Sheets("Sheet1").Activate
>> Range("B2").Select
>> Application.SendKeys ("%{DOWN}")
>> End Sub
>>
>> Then...Save the workbook.....Close it......then re-open it.
>>
>> Does that help?
>>
>> --------------------------
>>
>> Regards,
>>
>> Ron (XL2003, Win XP)
>> Microsoft MVP (Excel)
>>
>>
>>
>> "bethjoy79" <(E-Mail Removed)> wrote in message
>> news:13451359-7B25-49D4-826F-(E-Mail Removed)...
>> > 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" <(E-Mail Removed)> wrote in message
>> >> news:39736EAE-5B37-4527-B8C5-(E-Mail Removed)...
>> >> >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
>> >>
>> >>
>> >>
>>
>>
>>