Hyperlinking into specific worksheet within an Excel File

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
As a New User you should ask you questions in the correct group. Try the
Excel newsgroup.
 
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.
 
I have tried naming a range in cell A1, but each time it will open to the
last page the file was saved at.
 
Back
Top