Dropdown list of hyperlinks
 

In xl2007

I have a workbook with many worksheets. I'd like to have, on each sheet, a
dropdown list of hyperlinks to all of the sheets in the workbook.

I'd like our users to be able to click on the dropdown arrow, select a sheet
from the list and go to that sheet. (even a predetermined cell on the
selected sheet if possible)

Because of the number of sheets involved I think a dropdown with scroll bar
would be much more user-friendly than the tab list along the bottom.

Thanks to Tim Zych I have a list of sheet names on a "Master" sheet that
might be used as a source.

I envision something that looks like the Data Validation List dropdown but
has the hyperlink capability.

Any assistance with this will be greatly appreciated.

Dropdown list of hyperlinks
 

Might be easier to look at these alternatives.

Right-click on one of the sheet navigation arrows to get a 15 sheet listing
and "more".

Another option................................

You can build a Navigation Toolbar as per Dave's code on Debra Dalgleish's
site. Sorts as well as navigates.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw

Personally, I prefer Bob's method.


Gord Dibben MS Excel MVP

On Wed, 18 Mar 2009 16:38:11 -0500, "Bassman62"
wrote:

In xl2007

I have a workbook with many worksheets. I'd like to have, on each sheet, a
dropdown list of hyperlinks to all of the sheets in the workbook.

I'd like our users to be able to click on the dropdown arrow, select a sheet
from the list and go to that sheet. (even a predetermined cell on the
selected sheet if possible)

Because of the number of sheets involved I think a dropdown with scroll bar
would be much more user-friendly than the tab list along the bottom.

Thanks to Tim Zych I have a list of sheet names on a "Master" sheet that
might be used as a source.

I envision something that looks like the Data Validation List dropdown but
has the hyperlink capability.

Any assistance with this will be greatly appreciated.

Dropdown list of hyperlinks
 

Thank you kindly.
Sometimes I can certainly complicate the situation.
Regards

"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Might be easier to look at these alternatives.

Right-click on one of the sheet navigation arrows to get a 15 sheet
listing
and "more".

Another option................................

You can build a Navigation Toolbar as per Dave's code on Debra
Dalgleish's
site. Sorts as well as navigates.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw

Personally, I prefer Bob's method.


Gord Dibben MS Excel MVP

On Wed, 18 Mar 2009 16:38:11 -0500, "Bassman62"
wrote:

In xl2007

I have a workbook with many worksheets. I'd like to have, on each sheet, a
dropdown list of hyperlinks to all of the sheets in the workbook.

I'd like our users to be able to click on the dropdown arrow, select a
sheet
from the list and go to that sheet. (even a predetermined cell on the
selected sheet if possible)

Because of the number of sheets involved I think a dropdown with scroll
bar
would be much more user-friendly than the tab list along the bottom.

Thanks to Tim Zych I have a list of sheet names on a "Master" sheet that
might be used as a source.

I envision something that looks like the Data Validation List dropdown but
has the hyperlink capability.

Any assistance with this will be greatly appreciated.

Dropdown list of hyperlinks
 

Thanks for the feedback.

Beats the heck out of having a dropdown on every sheet<g


Gord

On Wed, 18 Mar 2009 17:06:11 -0500, "Bassman62"
wrote:

Thank you kindly.
Sometimes I can certainly complicate the situation.
Regards

"Gord Dibben" <gorddibbATshawDOTca wrote in message
.. .
Might be easier to look at these alternatives.

Right-click on one of the sheet navigation arrows to get a 15 sheet
listing
and "more".

Another option................................

You can build a Navigation Toolbar as per Dave's code on Debra
Dalgleish's
site. Sorts as well as navigates.

http://www.contextures.on.ca/xlToolbar01.html

Or see this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw

Personally, I prefer Bob's method.


Gord Dibben MS Excel MVP

On Wed, 18 Mar 2009 16:38:11 -0500, "Bassman62"
wrote:

In xl2007

I have a workbook with many worksheets. I'd like to have, on each sheet, a
dropdown list of hyperlinks to all of the sheets in the workbook.

I'd like our users to be able to click on the dropdown arrow, select a
sheet
from the list and go to that sheet. (even a predetermined cell on the
selected sheet if possible)

Because of the number of sheets involved I think a dropdown with scroll
bar
would be much more user-friendly than the tab list along the bottom.

Thanks to Tim Zych I have a list of sheet names on a "Master" sheet that
might be used as a source.

I envision something that looks like the Data Validation List dropdown but
has the hyperlink capability.

Any assistance with this will be greatly appreciated.