I know how to create a drop down menu and I know how to create a
hyperlink (using a source on another worksheet within the workbook),
however, I can't seem to create a drop down menu that contains
hyperlinks.

Thanks for any help, it's greatly appreciated.


--
B_Ward
------------------------------------------------------------------------
B_Ward's Profile: http://www.excelforum.com/member.php...o&userid=29829
View this thread: http://www.excelforum.com/showthread...hreadid=495330

Create the dropdown and react to the selection, performing the same action
as a hyperlink would. (so simulate a hyperlink).

--
Regards,
Tom Ogilvy



"B_Ward" wrote in
message ...

I know how to create a drop down menu and I know how to create a
hyperlink (using a source on another worksheet within the workbook),
however, I can't seem to create a drop down menu that contains
hyperlinks.

Thanks for any help, it's greatly appreciated.


--
B_Ward
------------------------------------------------------------------------
B_Ward's Profile:
http://www.excelforum.com/member.php...o&userid=29829
View this thread: http://www.excelforum.com/showthread...hreadid=495330

Thanks for your quick response!!

I've tried placing the hyperlinks four each of the sources for the
list. The link works on that worksheet; however, when I tell the drop
down menu to use that list as the source, the values appear, but the
links do not work.

How do I simulate a hyperlink?

Thanks again for your help!


--
B_Ward
------------------------------------------------------------------------
B_Ward's Profile: http://www.excelforum.com/member.php...o&userid=29829
View this thread: http://www.excelforum.com/showthread...hreadid=495330