Remove All Hyperlinks in MS Word or Excel
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 Macros below.
Word
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
You can now run the Macro in Word by going to:
Tools > Macro > Macro and then Run “RemoveAllHyperlinks”
Excel:
You can do the same in an Excel Document:
Hit [ALT]+[F11] to open the Visual Basic Editor
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
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”, this will delete all URLS on the selected worksheet.
Google…
[...]although web-sites we backlink to beneath are considerably not connected to ours, we really feel they are actually really worth a go through, so have a look[...]…
Digg…
While checking out DIGG today I found this…
marketing online…
[...]just below, are some totally unrelated sites to ours, however, they are definitely worth checking out[...]…
A gaming website recommends your website…
[...]check below, couple of totally unrelated websites to ours, however, they're most trustworthy sources that individuals use[...]…
Great Clips Coupons…
[...]the following are several links to web sites I always connect to as we believe they really are worth visiting[...]…
Found=> likes your page…
[...] Every onсe in a basically wе choose blogs that mаny оf uѕ read. Let us discuss the mоѕt up-to-date sites that individuals choose [...]…
Superb website…
[...]always a big fan of linking to bloggers that I love but don’t get a lot of link love from[...]……
Wikia…
Wika linked to this website…
Cool news from asia, fun ppl around the world, One world !…
[...]blow are some sites that we think it will be worth your time[...]…
Websites we think you should visit…
[...]although websites we backlink to below are considerably not related to ours, we feel they are actually worth a go through, so have a look[...]……
buy damansara house…
[...]you will find information that’s relevant to you if you want to buy damansara house[...]…
Cool sites…
[...]we came across a cool site that you might enjoy. Take a look if you want[...]……
Recommeneded websites…
[...]Here are some of the sites we recommend for our visitors[...]……
News info…
I was reading the news and I saw this really interesting topic…
Dreary Day…
It was a dreary day here yesterday, so I just took to piddeling around on the internet and found…
Online Article……
[...]The information mentioned in the article are some of the best available [...]……
Angry Birds Online…
[...]listed below are a handful of links to web sites which we link to seeing that we believe these are definitely worth browsing[...]…
Garmin 1490t Best Price…
[...]the time to read or visit the content or sites we have linked to below the[...]…
Cool sites…
[...]we came across a cool site that you might enjoy. Take a look if you want[...]……
Should I stay or should I go now…
Currently I need to figure out whether to keep reading of the site, or go to some other site….
cheap webhosting…
[...]This extremely relates to the topics I was just writing concerning[...]…
Yahoo results…
While browsing Yahoo I discovered this page in the results and I didn’t think it fit…
Gems form the internet……
[...]even though the sites we connect with above are not associated with us, however are worth visiting[...]……
How to Cure Tinnitus…
[...]the time to read or visit the content or sites we have linked to below the[...]…
blackhat search tips…
[...]while the sites we link to below are completely unrelated to ours, we think they are worth a read, so have a look[...]…
travel…
[...]below you’ll find the link to some sites that we think you should visit[...]…
Cool news from asia, fun ppl around the world, One world !…
[...]blow are some sites that we think it will be worth your time[...]…
Ipad Stylus…
[...]listed below are several web page links to websites I always link to since we believe they’re definitely worth browsing[...]…
Our family favs….
[...]just below, are some totally unrelated sites to ours, however, they are definitely worth checking out[...]…
Creative Wedding videos that you must check out !…
[...]we like to honor other sites on the web, even if they aren’t related to us, by linking to them. Below are some sites worth checking out[...]…
Digg…
While checking out DIGG yesterday I noticed this…
Its hard to find good help…
I am constantnly proclaiming that its hard to find quality help, but here is…
Check this out…
[...]we came across a cool site that you might enjoy. Take a look if you want[...]…
Cool news from asia, fun ppl around the world, One world !…
[...]blow are some sites that we think it will be worth your time[...]…
Blogs ou should be reading…
[...]Here is a Great Blog You Might Find Interesting that we Encourage You[...]……
Recent Blogroll Additions……
[...]usually posts some very interesting stuff like this. If you’re new to this site[...]……