Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-Down List
I want to make a drop-down list that contains the names of the various
worksheets on my workbook. I want it so that when I pick the name of the worksheet it will automatically takes me to that sheet. Does anyone know how to do this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-Down List
Dawn
First of all...........you can right-click on any of the navigation arrows at lower left of sheet tab list and see 15 sheets and "more sheets". If you truly need more than that..................... Rather than an dropdown list sheet with hyperlinks, try a sheet navigation toolbar or similar. Sheet navigation bar from by Dave Peterson at Debra Dalgleish's site. http://www.contextures.on.ca/xlToolbar01.html Or Bob Phillips' Browsesheets macro. See this google search result. http://tinyurl.com/yoa3dw Gord Dibben MS Excel MVP On Wed, 23 Jan 2008 07:16:07 -0800, Dawn wrote: I want to make a drop-down list that contains the names of the various worksheets on my workbook. I want it so that when I pick the name of the worksheet it will automatically takes me to that sheet. Does anyone know how to do this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-Down List
thank you!
"Gord Dibben" wrote: Dawn First of all...........you can right-click on any of the navigation arrows at lower left of sheet tab list and see 15 sheets and "more sheets". If you truly need more than that..................... Rather than an dropdown list sheet with hyperlinks, try a sheet navigation toolbar or similar. Sheet navigation bar from by Dave Peterson at Debra Dalgleish's site. http://www.contextures.on.ca/xlToolbar01.html Or Bob Phillips' Browsesheets macro. See this google search result. http://tinyurl.com/yoa3dw Gord Dibben MS Excel MVP On Wed, 23 Jan 2008 07:16:07 -0800, Dawn wrote: I want to make a drop-down list that contains the names of the various worksheets on my workbook. I want it so that when I pick the name of the worksheet it will automatically takes me to that sheet. Does anyone know how to do this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-Down List
Actually I want it embedded on my main worksheet not as a toolbar. Is that
possible? "Gord Dibben" wrote: Dawn First of all...........you can right-click on any of the navigation arrows at lower left of sheet tab list and see 15 sheets and "more sheets". If you truly need more than that..................... Rather than an dropdown list sheet with hyperlinks, try a sheet navigation toolbar or similar. Sheet navigation bar from by Dave Peterson at Debra Dalgleish's site. http://www.contextures.on.ca/xlToolbar01.html Or Bob Phillips' Browsesheets macro. See this google search result. http://tinyurl.com/yoa3dw Gord Dibben MS Excel MVP On Wed, 23 Jan 2008 07:16:07 -0800, Dawn wrote: I want to make a drop-down list that contains the names of the various worksheets on my workbook. I want it so that when I pick the name of the worksheet it will automatically takes me to that sheet. Does anyone know how to do this? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop-Down List
Use Bob's browsesheets macro in that case.
Copy the macro to a general module in your workbook. Add a button from the Forms Toolbar to your main worksheet.. Right-click and assign browsesheets macro to that button. But take note that you now have no way to run the macro after you have selected another sheet, unless you copy the button to every sheet. Gord On Thu, 24 Jan 2008 06:06:01 -0800, Dawn wrote: Actually I want it embedded on my main worksheet not as a toolbar. Is that possible? "Gord Dibben" wrote: Dawn First of all...........you can right-click on any of the navigation arrows at lower left of sheet tab list and see 15 sheets and "more sheets". If you truly need more than that..................... Rather than an dropdown list sheet with hyperlinks, try a sheet navigation toolbar or similar. Sheet navigation bar from by Dave Peterson at Debra Dalgleish's site. http://www.contextures.on.ca/xlToolbar01.html Or Bob Phillips' Browsesheets macro. See this google search result. http://tinyurl.com/yoa3dw Gord Dibben MS Excel MVP On Wed, 23 Jan 2008 07:16:07 -0800, Dawn wrote: I want to make a drop-down list that contains the names of the various worksheets on my workbook. I want it so that when I pick the name of the worksheet it will automatically takes me to that sheet. Does anyone know how to do this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
how do I link a drop down list entry to a new drop down cell? | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |