Drop down list

[tofimoon3 via OfficeKB.com]

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.

 

[Stefi]

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:

 

[Dave Peterson]

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 here:
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.)