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 said:
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?
