Hi John:

The technique is to use the HYPERLINK() function. Say the list of email
addresses is from Z1 thru Z100. We put the data validation dropdown in A1.
When an address is picked, it will be "cold" (un-clickable). So in A2 enter:

=HYPERLINK("mailto:" & A1,A1)

A2 will be "clickable"


--
Gary''s Student - gsnu200788


"John Calder" wrote:

Hi

I run Excel 2000

I have a list of names with each one of them having a hyperlink to an email
address.

These all work fine.

What I would like to do is one of two things.

1st Option

Have a drop down list that lets me choose one of the names from the list and
have it retain its hyperlink properties. I tried using data validation but
the names dont retain their hyperlink properties.

2nd Option

Have a formula that is based on an entry to another cell that returns the
name from the list but retains the hyperlink properties.

Example (in cell G1)

=IF(D1="SUPPLIER 1",HYPERLINK(A1))

(I tried this but it dosnt work so it may be that I have the formula wrong)

Can anyone help?


Thanks


John