Not clear.but perhaps:

If you want to select a sheet from the Table of Contents you could
use a hyperlink, or your could use a double-click event macro.

http://www.mvps.org/dmcritchie/excel/event.htm
http://www.mvps.org/dmcritchie/excel....htm#GoToSheet

Event macros such as doubleclick are installed by right clicking on the
sheettab then inserting the code after choosing View Code.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"EAHRENS" wrote in message ...
This worked great. I am also running a macro that forces a user to enter a
new name and excel then changes the file to that name and goes to the table
of contents. Is there a way to write a macro that will also change the macro
you gave me to change from the "intro" sheet to the "table of contents sheet"
when the file is saved under the new name.

"Alan" wrote:

You cant do this in a shortcut as far as I know, but this code in the VB
editor 'This Workbook' will do the trick,
Post back if you're unfamiliar with VB code,
Regards,
Alan.
Private Sub Workbook_Open()
Sheets("Intro").Select
End Sub

"EAHRENS" wrote in message
...
I need to know how to modify an excel shortcut to make a file always open
to
a specific named "intro" sheet.