| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Drop down list
Dear sir,with best regards, i have a workbook with main sheet and about (20)
agents sheets,is it possible in excel 2003 to create a drop down list for these sheets when i press any agent name from this list its sheet will open. Thanks in advance. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200902/1 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Drop down list
Excel gives you almost exactly the same feature by right clicking on the
bottom left corner of the workbook window (on the ”‚—„ —„ –º –º”‚ icons). Regards, Stefi €žtofimoon3 via OfficeKB.com€ ezt Ã*rta: Dear sir,with best regards, i have a workbook with main sheet and about (20) agents sheets,is it possible in excel 2003 to create a drop down list for these sheets when i press any agent name from this list its sheet will open. Thanks in advance. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200902/1 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Drop down list
You could create a list of hyperlinks on a worksheet that you treat as a
table of contents. David McRitchie has some code that creates a table of contents (using hyperlinks): http://www.mvps.org/dmcritchie/excel/buildtoc.htm Another option if you want a more generic solution: http://contextures.com/xlToolbar01.html (From Debra Dalgleish's site.) It builds a toolbar that you can use with any workbook to navigate to any worksheet. There's a link to an xl2007/ribbon version (by Ron de Bruin) on Debra's site. ======= If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) "tofimoon3 via OfficeKB.com" wrote: Dear sir,with best regards, i have a workbook with main sheet and about (20) agents sheets,is it possible in excel 2003 to create a drop down list for these sheets when i press any agent name from this list its sheet will open. Thanks in advance. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...l-new/200902/1 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list dependant on previous drop down list | Excel Discussion (Misc queries) | |||
| Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
| 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) | |||
Linear Mode
