Word: Macro to unlink hyperlinks

November 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.


  1. when recording a macro, can I include a link to an email? I’ve tried but when recording the macro, I cannot click on the link. Suggestions?

  2. Hi Sherrye

    I have no idea. I suggest you ask this in the Microsoft Answers forums (http://answers.microsoft.com).


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: