MrExcel Publishing
Your One Stop for Excel Tips & Solutions

hyperlink and bookmarks


Posted by Gregg on February 09, 2002 11:47 AM

I am trying to hyperlink a bookmark from a word document to a cell in an excel spreadsheet. I can hyperlink the word document, but not the bookmark within the word document -- I know it's possible to do. I keep getting an error message when I try to link the book marked word document. Can you tell me how to make the hyperlink work? Could you also give an example? Thanks.
Gregg


Posted by Lewis (1) on February 10, 2002 4:52 AM

I'm not entirely clear what you are trying to do, but putting #bookmarkname after the document name should link to the bookmark. To Link to a particular cell in Excel you need to name the cell.

Select the cell you want to link to.
In the top left hand corner you will see the cell address.
Click on this.
Type in the name you want to use
Enter.

When you set up your hyperlink to Excel if you link to myexcelfile.xls#mycellname this should open the worksheet and go to the named cell.

Hope this helps.
If not post follow up