I'd like to use VBA to insert a cross reference link to the table of contents for every time it finds the text "Click to Return to Table of Contents"



This can't be an ordinary hyperlink to a place in the document, because when I save as PDF, it breaks the link. If I insert a cross reference, it works fine when I convert to PDF.

The table of contents only includes heading 1, and does not include the words "Table of Contents" as part of the table. I have manually inserted a bookmark named "TableofContents" at the top of the table. The text the bookmark displays is "Table of Contents" and it is to this point I need to link.

If you save a document as a PDF and use the 'Create bookmarks using Headings' option, the bookmarks pop-out in Adobe Reader functions as an expandable Table of Contents.

Anything fancier would require you to bookmark both the Table of Contents and every Heading in the document, so your save-as could use the 'Create bookmarks using bookmarks' option.

As for your "Click to Return to Table of Contents" requirement, all you need do is create the cross-reference once, then copy that to the clipboard and use Find/Replace to replace all the other instances with the clipboard contents. No code required.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

What is the cross-reference anchor text showing? If it is a cross-reference, that would imply that the words "Click to Return to Table of Contents" need to appear at the top of the TOC. A hyperlink is more flexible in that it doesn't need to be the same words as the location it is pointing to. If your hyperlinks are breaking, it is likely that your TOC field is being updated as part of the save and that the bookmarked range is inside the TOC field instead of being placed immediately in front of the TOC.

Paul's suggestion of using Find and Replace to create the multitude of links is by far the easiest way to do what you are asking for.

Placing these links all over the document for the express purpose of being able to bounce back to the TOC is not as quick as using the GoBack keyboard command. I would recommend you also teach users to press Alt-Left Arrow to return to the last clicked hyperlink.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia