| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Trying to add a drop down list of all worksheets for the user
We have 50 worksheets in an Excel file. I would like to provide a drop down
box or something of that nature for the user to select and automatically take them to the worksheet. Is there a way to do that? Is there also a way for the user to get back? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trying to add a drop down list of all worksheets for the user
If you don't currently have any macros in the workbook and didn't plan on
adding some...try this: Put a Table of Contents sheet in the workbook and insert hyperlinks to the individual sheets. From the Excel main menu: <insert<hyperlink Click the "Place in this document" button Select a sheet and cell Enter the "friendly name" (eg: "Summary Report Page") Click the [OK] button OR You might want to use the HYPERLINK function and have it refer to nearby cells for the link location text and the friendly names. On the target sheets...you could put hyperlinks that refer back to the table of contents. Post back with any questions. Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Steve" wrote: We have 50 worksheets in an Excel file. I would like to provide a drop down box or something of that nature for the user to select and automatically take them to the worksheet. Is there a way to do that? Is there also a way for the user to get back? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Trying to add a drop down list of all worksheets for the user
Ron,
That is perfect. Thanks a bunch! "Ron Coderre" wrote: If you don't currently have any macros in the workbook and didn't plan on adding some...try this: Put a Table of Contents sheet in the workbook and insert hyperlinks to the individual sheets. From the Excel main menu: <insert<hyperlink Click the "Place in this document" button Select a sheet and cell Enter the "friendly name" (eg: "Summary Report Page") Click the [OK] button OR You might want to use the HYPERLINK function and have it refer to nearby cells for the link location text and the friendly names. On the target sheets...you could put hyperlinks that refer back to the table of contents. Post back with any questions. Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Steve" wrote: We have 50 worksheets in an Excel file. I would like to provide a drop down box or something of that nature for the user to select and automatically take them to the worksheet. Is there a way to do that? Is there also a way for the user to get back? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop Down List Box, Combo Box | Excel Discussion (Misc queries) | |||
| Drop down list from another drop down list | Excel Discussion (Misc queries) | |||
| Advanced Excel Drop down List | 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) | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Linear Mode
