Hyperlinking to a Word Bookmark
To create a hyperlink in Excel that points to bookmark in Word, you need to provide a SubAddress. Insert a hyperlink normally by using Insert>Hyperlink.
When you type your path in the textbox, include a pound sign (#) and the name of the bookmark. Like this
When you click on the hyperlink, the Word document will open and jump to the bookmark. Whoopee!
THAT DOESNT WORK!!!!!!!!!!!!
I tried and it works great!!
Thank you! I don’t know why that information isn’t in the help files in Word or Excel. I don’t know what I would do without your site.
Just wanted to clarify. It works perfectly but you have to do it when the instructions say to (ie. while creating the hyperlink). You can’t just add “#BookmarkName” to the end of the text in a cell that represents the hyperlink. It wont work that way since the text in the cell is merely the text of the hyperlink and not the hyperlink itself.
If you set up this Macro:
Sub Macro2()
‘
‘ Macro2 Macro
‘ Macro recorded 05/03/2009 by David Torrens
‘
‘ Keyboard Shortcut: Ctrl+j
Dim CellValue As String
CellValue = ActiveCell.Value
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:=CellValue, _
TextToDisplay:=CellValue
ActiveCell.Offset(1, 0).Activate
‘
End Sub
it will turn the text in a cell into a hyperlink andf jump to the next cell down.
Brilliant, Thank you