Go Back   TechArena Community > Software > Tips & Tweaks
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to remove all hyperlinks in Microsoft word

Tips & Tweaks


Reply
 
Thread Tools Search this Thread
  #1  
Old 02-02-2009
Member
 
Join Date: Jan 2009
Posts: 39
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.

Reply With Quote
  #2  
Old 02-02-2009
Member
 
Join Date: Apr 2008
Posts: 436
Re: How to remove all hyperlinks in Microsoft word

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!
Reply With Quote
  #3  
Old 02-02-2009
Member
 
Join Date: Jan 2009
Posts: 39
Re: How to remove all hyperlinks in Microsoft word

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.......
Reply With Quote
  #4  
Old 02-02-2009
Member
 
Join Date: Apr 2008
Posts: 586
Re: How to remove all hyperlinks in Microsoft word

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.
Reply With Quote
  #5  
Old 04-02-2009
Member
 
Join Date: Feb 2009
Posts: 2
Re: How to remove all hyperlinks in Microsoft word

click on hyperlink toolbar and delete all the links.that's all.
Reply With Quote
  #6  
Old 04-02-2009
Member
 
Join Date: Apr 2008
Posts: 437
Re: How to remove all hyperlinks in Microsoft word

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
Reply With Quote
  #7  
Old 04-02-2009
Member
 
Join Date: Apr 2008
Posts: 392
Re: How to remove all hyperlinks in Microsoft word

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
Reply With Quote
  #8  
Old 27-02-2009
Member
 
Join Date: Feb 2009
Posts: 1
Re: How to remove all hyperlinks in Microsoft word

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
Reply With Quote
  #9  
Old 27-11-2009
ramcio
 
Posts: n/a
Re: How to remove all hyperlinks in Microsoft word

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.
Reply With Quote
  #10  
Old 07-12-2009
pritamsingh98
 
Posts: n/a
Re: How to remove all hyperlinks in Microsoft word

with the help of hyperlink tool bar
Reply With Quote
  #11  
Old 15-12-2009
Member
 
Join Date: Dec 2008
Location: Colombo
Posts: 121
Re: How to remove all hyperlinks in Microsoft word

By Hyper link tool bar u can do this
Reply With Quote
  #12  
Old 18-12-2009
archi
 
Posts: n/a
Re: How to remove all hyperlinks in Microsoft word

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.
Reply With Quote
Reply

  TechArena Community > Software > Tips & Tweaks
Tags: , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to remove all hyperlinks in Microsoft word"
Thread Thread Starter Forum Replies Last Post
need help to remove files of Microsoft word 2010 kEyURi Windows Software 4 28-10-2011 02:27 PM
Need help for Microsoft Word 2007 Document password Recovery/ remove Eashta^devata Windows Software 2 17-09-2011 11:32 PM
Microsoft office 2011 for Mac : Microsoft word cannot be open showing error RidD Windows Software 5 12-09-2011 11:01 PM
Docx file is incompatible between Microsoft Word 2010 and Word 2007 Angee Windows Software 3 14-05-2011 08:28 PM
Hyperlinks in Word - can't open them iano Windows Software 4 17-04-2009 08:31 AM


All times are GMT +5.5. The time now is 07:04 PM.