I proposed this question the other day and recieved a helpful answer, but I am still confused and struggling with the problem....

I want to create a drop down list that allows me to make a selection from a group of choices. When I click on the selection, I want to be directed to a hyperlinked worksheet (in the same workbook). Creating hyperlinks is not a problem for me, but having them act as a hyperlink in the drop down list is generating a problem.

Any help is greatly appreciated.