There may be a way but I can't think of one offhand. You could just create
regular hyperlinks in each cell and have the user click the appropriate cell.

Or...you could create a regular drop down menu and have a macro run that
would activate the appropriate cell based on the value the user chose from
the drop down menu. You would need to do coding for that though. Probably
in the SheetChange event with the cell where you put the drop down list as
the target.

Hope this helps.

Bill Horton

"B_Ward" wrote:


Does anyone know how to create a drop down menu that contains hyperlinks
to different parts of the same worksheet? Thanks for any help!!!

-Brian


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