Word: Macro to unlink hyperlinksNovember 1, 2010
You’ve copied a table of data from a web page and the items in the cells are links to other pages. You have a macro that you run to reformat the table in Word so that it meets your requirements. However, the links are still clickable, although the blue underline on them has gone (as part of your macro). You want to get rid of that ‘clickability’.
You can remove a hyperlink from any selected text by pressing Ctrl+Shift+F9.
However, you can also add this function to your existing macro to save you having to do another formatting step. The VBA code for unlinking a hyperlink is:
Be careful with this macro. If you select the entire document and run it, you’ll unlink everything that’s linked — table of contents, automated cross-references, automated caption numbering, any other automated fields… Just use it on selected text, NOT the entire document.