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?

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?

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?