I want to use a drop down list to select a spreadsheet or other location and
hyper link to it. Does anyone have any creative was to do this?

you already can right-click the lower left-hand control (arrows to the
left of the worksheet tabs) to get a pop-up from which you can choose a
worksheet.

In article ,
djp wrote:

I want to use a drop down list to select a spreadsheet or other location and
hyper link to it. Does anyone have any creative was to do this?

Thanks for the input. I would like to do it from a cell in the spreadsheet.

"JE McGimpsey" wrote:

you already can right-click the lower left-hand control (arrows to the
left of the worksheet tabs) to get a pop-up from which you can choose a
worksheet.

In article ,
djp wrote:

I want to use a drop down list to select a spreadsheet or other location and
hyper link to it. Does anyone have any creative was to do this?

"djp" wrote:

I want to use a drop down list to select a spreadsheet or other location from a cell and hyper link to it that location.