Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Navigating between worksheets using a drop down menu
I have been searching the forums but I don't seem to hit the correct search criterias, please help I need to create a drop down menu on one of my worksheets. The list should contain all the woksheet/tabs in the workbook and allow me to navigate to any sheet. When a new sheet is added it should also be added to the drop down menu. -- ncdogteam ------------------------------------------------------------------------ ncdogteam's Profile: http://www.excelforum.com/member.php...o&userid=36342 View this thread: http://www.excelforum.com/showthread...hreadid=561281 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Navigating between worksheets using a drop down menu
Hi, The attached link might get you started http://www.contextures.com/xlToolbar01.html VBA Noob -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=561281 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Navigating between worksheets using a drop down menu
I have written my own code to do this and I will email it to you if you
would like, however, if you right click the arrows that let you navigate the next/previous sheet it pops up a menu that lets you select the sheet you wish to go to. HTH Die_Another_Day ncdogteam wrote: I have been searching the forums but I don't seem to hit the correct search criterias, please help I need to create a drop down menu on one of my worksheets. The list should contain all the woksheet/tabs in the workbook and allow me to navigate to any sheet. When a new sheet is added it should also be added to the drop down menu. -- ncdogteam ------------------------------------------------------------------------ ncdogteam's Profile: http://www.excelforum.com/member.php...o&userid=36342 View this thread: http://www.excelforum.com/showthread...hreadid=561281 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Navigating between worksheets using a drop down menu
XL has a built-in sheet list that is accessible by simply right clicking in
the small directional arrows to the left of the sheet tabs. This gives you a list of the first 15 sheets, with an option to expand the list to an infinitely scrolling list of *all* the sheets. Click on a name, and the sheet is immediately selected. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "ncdogteam" wrote in message ... I have been searching the forums but I don't seem to hit the correct search criterias, please help I need to create a drop down menu on one of my worksheets. The list should contain all the woksheet/tabs in the workbook and allow me to navigate to any sheet. When a new sheet is added it should also be added to the drop down menu. -- ncdogteam ------------------------------------------------------------------------ ncdogteam's Profile: http://www.excelforum.com/member.php...o&userid=36342 View this thread: http://www.excelforum.com/showthread...hreadid=561281 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Navigating between worksheets using a drop down menu
Maybe you can use or adapt this (which uses a toolbar):
http://www.contextures.com/xlToolbar01.html from Debra Dalgleish's site. ncdogteam wrote: I have been searching the forums but I don't seem to hit the correct search criterias, please help I need to create a drop down menu on one of my worksheets. The list should contain all the woksheet/tabs in the workbook and allow me to navigate to any sheet. When a new sheet is added it should also be added to the drop down menu. -- ncdogteam ------------------------------------------------------------------------ ncdogteam's Profile: http://www.excelforum.com/member.php...o&userid=36342 View this thread: http://www.excelforum.com/showthread...hreadid=561281 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I select from drop down menu I would like the next column to populate a specific cost. | Excel Worksheet Functions | |||
How to create a drop down menu which referencing a different workb | Excel Discussion (Misc queries) | |||
How do I set up a drop down menu within a drop down menu? | Excel Discussion (Misc queries) | |||
Drop down menu | Excel Discussion (Misc queries) | |||
help with drop down menu data | Excel Discussion (Misc queries) |