How to remove all hyperlinks in Microsoft word

Hello People,

I am working on my project in MS word. There are many hyperlinks in my document. I am fed up of right clicking and removing those one by one. Can anyone tel me how to delete them all at a time?

Thanks in advance.

You can remove it eaily with the help of Macros. Just follow some simple steps given below and see the magic.

• Open your MS word Document.
• Press "Alt+F11" - it will open the Visual Basic Editor
• Click Insert on Menu bar
• Click Module

In the new pop-up window copy following:

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 and Close and return to Microsoft Word

After that Run Macro -
Tools > Macro > Macro and then Run “RemoveAllHyperlinks”

DONE!:biggrin:

I have the same problem but not in MS word, in MS excel. Can i do it in excel like in Word? Please need help guys.......

You can do the same in an Excel Document. But there's little difference.

Open your Excel spreadsheet that you wish to remove the hyperlinks from. Press <ALT>-F11 to go to the Visual Basic editor. Create a new module. You can do this by selecting Module under the Insert menu.

Copy and paste the following in new module:

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

Close the Visual Basic editor window by selecting "Close and Return to Microsoft Excel" under the File menu.

Tools > Macro > Macro and then Run “RemoveAllHyperlinks”, this will delete all URLS on the selected worksheet.

click on hyperlink toolbar and delete all the links.that's all.

Two Macros to remove Hyperlinks :

Macro 1: This one works great and is simpler than the second one. However, I am including the second one, just in case it has some extra functionality.

Type as below given:

1 Dim i As Long
2 For i = ActiveDocument.Hyperlinks.Count To 1 Step -1
3 ActiveDocument.Hyperlinks(i).Delete
4 Next i


Macro 2: Try this one too as it also works wonders:

1 Dim oField As Field
2 'Dim oRange As Range

For Each oField In ActiveDocument.Fields
If oField.Type = wdFieldHyperlink Then
'Set oRange = oField.Result
oField.Unlink
'oRange.Style = wdStyleHyperlink
End If
Next

Set oField = Nothing
'Set oRange = Nothing

You can remove hyperlinks by deleting the style called Hyperlink, or by hitting Ctrl+A, then Shift+Ctrl+F9 which will remove all underlying fields, but if you have a lot of documents that contain hyperlinks, this code speeds up Word's native function. A quicker way to do it if there are lots of hyperlinks per document, or you're using it as part of another procedure then There is a code for just the current document, and a code that will remove hyperlinks from all open documents is given below:


Option Explicit

Sub KillTheHyperlinks()
With This Document
While .Hyperlinks.Count > 0
Hyperlinks(1).Delete
Wend
End With
End Sub
Sub KillTheHyperlinksInAllOpenDocuments()
Dim doc As Document
Dim szOpenDocName As String
szOpenDocName = doc.Name
While .Hyperlinks.Count > 0
Hyperlinks(1).Delete
Wend
End With
Application.Options.AutoFormatAsYouTypeReplaceHyperlinks = False
Next doc
End Sub

to work down this code;


Open your Word document
Press Alt + F11 to open VBE
Insert-Module.
Paste the code there in the window at right.
Close VBE
Save the file


For executing the code:

Press Alt + F8 to open the macro dialog box
Select KillTheHyperlinks
Click Run

The easist way I know is:
Ctrl-A (select all)

Hold down all the following keys:
Ctrl
Shift
F9

Ctrl+Shift+F9

Good luck!

AwesomePcGuru

Ctrl+Shift+F9 only seems to remove the hyperlink for me, not the formatting. In order to get rid of the hyperlink formatting and the hyperlink here is what I do:
Ctrl+A
Ctrl+Shift+F9
Then click the hyperlink button to make the entire document a hyperlink.
Right click (while all the text is still selected) and click "remove hyperlink".

All hyperlinks and blue formatting will be gone.

with the help of hyperlink tool bar

By Hyper link tool bar u can do this

Hello Gopesh

It is very simple to remove all hyperlinks in MS word at once.

Follow these steps:
-Write numerical value 1 in any empty cell.
-Select and copy that cell
-Then Select all the area from where u want to remove the hyperlinks
-After selecting that area rgt click and select "Paste Special" option from the menu.
-From paste special box select "multiply" option and press ok button

After doing this u can chk all ur hyperlink will be removed.