If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|