MENU
Flipping Heck! Learning To Be Productive One Day At A Time

Remove All Hyperlinks in Excel and Word

Remove All Hyperlinks in Excel and Word

Remove All Hyperlinks in Excel and Word

Ever copy and paste something from the Internet and then into Word only to get the hyperlinks embedded? You can removed them easily with the Macro below.

Hit [ALT]+[F11] to open the Visual Basic Editor

Go to “Insert” > “Module” and in the pop-up window copy:

Sub RemoveHyperlinks()
Dim oField As Field
For Each oField In ActiveDocument.Fields
If oField.Type = wdFieldHyperlink Then
oField.Unlink
End If
Next
Set oField = Nothing
End Sub

Then click “File” > Close and return to Microsoft Word

Bottle of spilled pills on a blue table
Drug addiction is not a disease:  it is a psychological problem that is accompanied by a poor physical condition, and its origins lie in the person’s past, in his actions and problems. Let’s try to find out if a drug addict themselves can get rid of the addiction.

You can now run the Macro in Word by going to:

Tools > Macro > Macro and then Run “RemoveAllHyperlinks”

You can do the same in an Excel Document:

Hit [ALT]+[F11] to open the Visual Basic Editor

From Passion To Profit

Go to “Insert” > “Module” and in the pop-up window copy:

Sub RemoveHyperlinks()
‘Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub

Weekly Round-Up - Cowboy Lassoing Text
In this week's round-up we take a look back at out Autumn Cleaning Challenge series that ran throughout October. I also introduce a new monthly segment to my round-up where I take a look back at what I've been up to over then month and this month I discuss how...

Then click “File” > Close and return to Microsoft Excel

You can now run the Macro in Excel by going to:

Tools > Macro > Macro and then Run “RemoveAllHyperlinks”

blank
About The Author
Katy is always trying to be more productive one day at a time! Whether it's analogue, digital, motivational or psychological who'll try any system that will help her get things done and get organised. As well as running FlippingHeck.com, she also loves making music and reviewing things.
  • Follow Katy Whitton on:
  • blank
  • blank
  • blank
  • blank
  • blank
  • blank
  • blank
  • blank
Please Note: This post may contain affiliate links. By clicking on these links you will not be charged any extra for purchasing goods and services from our preferred partners however flippingheck.com may receive financial compensation which contributes to the running of the site. For more information please read our Advertising & Affiliate Disclosure Policy
Filed Under:

8 Comments

  •  
    blank

    “Umm…. only one problem…. microsoft word 2007 and excel 2007, do NOT have a “”Tools”” > option !!! Or, I can not find it.

    Where do I find the Tools option?”

  •  
    blank

    “Here’s Microsoft’s guide to changing macro settings in Office 2007:

    http://office.microsoft.com/en-us/excel/hp100969191033.aspx “

  •  
    blank

    “Hey- This macro has worked for me before but now I am getting a Run Time error when I run the macro: Method ‘Delete’ of object ‘Hyperlinks’ failed

    What am I doing wrong? Any thoughts?”

  •  
    blank

    “A thank, thanks, and half a thank!
    Times infinity plus one!
    Thanks,
    Duane”

  •  
    blank

    “No Problem Duane!”

  •  
    blank

    “Hi,
    When I try to run the macro in excel, i get the message saying “”Macros have been disabled””
    I am kind of new to using macros.. can you help me out here please
    thank you,
    Prema”

  •  
    blank

    “@Prema – You need to lower your macro security level to allow you to run macros.

    You can either switch it to Medium (in which case you’ll be prompted on startup whether to enable/disable the macros) or Low (macros are enabled by default, could be a safety risk). It’s up to you to choose a security level you feel comfortable with.

    Change the security by going Tools > Macro > Security and selecting the proper level for your application.”

  •  
    blank

    “Thanks very much buddy! saved me a ubunch of time :)”

Leave a Reply

Your email address will not be published. Required fields are marked *