If this is your first time to do this stuff you don't need to worry about it, it's really very easy to do it...
Now for removing the hyperlinks in MS OFFICE WORD what you need to do
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
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”
For the excel documents:
Remember that in Excel Document. it's a little different.
Open Excel spreadsheet that you want to remove the hyperlinks from. Press
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.
