|
| 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
February 27th, 2009, 09:30 AM
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
February 27th, 2009, 11:23 AM
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
February 27th, 2009, 04:28 PM
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
