Hyperlinking into specific worksheet within an Excel File

[Guest]

How do I create a hyperlink into a specific worksheet within an Excel file? I
tried using a (#) bookmark referencing the tab name, but each time the Excel
file opens it enters into the worksheet where the file was saved.

 

[Andrew Murray]

As a New User you should ask you questions in the correct group. Try the
Excel newsgroup.

 

[Guest]

Save the pages as web pages (.htm or .html) and hyperlink directly to the
page that way.

 

[Stefan B Rusynko]

Create a named range in the Excel sheet you want to open
(in cell A1 or any cell you want to go to)
- In sheet 5 create a named range as say "startsheet5"
Then link it as a bookmark using the named range
workbookname.XLS#startsheet5

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| How do I create a hyperlink into a specific worksheet within an Excel file? I
| tried using a (#) bookmark referencing the tab name, but each time the Excel
| file opens it enters into the worksheet where the file was saved.
| --
| New user looking for quick answers.

 

[Meck2003]

I have tried naming a range in cell A1, but each time it will open to the
last page the file was saved at.