Hi,
There are programs for that, but Excel does not handle this. You could
attach a macro to the hyperlink and have the macro prompt you for with
hyperlink(s) to open.
If this helps, please click the Yes button
cheers,
Shane Devenshire
"FredN" wrote in message
...
Thanks. This was very helpful but now I want to up the ante and place two
hyperlinks in one cell. Possible? Thanks again.
--
FredN
"David McRitchie" wrote:
And with Dave's answer that solved your problem, hopefully you looked up
HYPERLINK Worksheet Formula in your HELP, so
the link would might look something like:
=hyperlink("C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01", "bookmarks")
If you also want to link Excel documents, see
http://www.mvps.org/dmcritchie/excel/sheets.htm
Basically if you can create a link in an HTML document you should
have little problem creating a link in Excel or MS Word.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"Alan" wrote in message
...
Dave
Many Thanks ... searched the posts, but missed that
"Dave Peterson" wrote:
Saved from a previous post:
So you want to add a hyperlink in an excel document that links to a
certain
location in an MSWord file?
If I want a link in Excel that points at a specific location in an
MSWord
document, I'd add a bookmark to that document and use one of these:
(Insert|hyperlink style)
C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01
Or
=hyperlink() style:
=hyperlink("C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01")
Alan wrote:
I have a TOC in excel that hyperlinks to various documents. This
only
provides a broad link to the first page of the document... is there
a way I
can link this to individual chapters and headings ??? similar to a
toc index
in word ???
Maybe im missing something obvious .. any help would be appreciated
Many Thanks
--
Dave Peterson