-
Website
http://www.tech-recipes.com/ -
Original page
http://www.tech-recipes.com/rx/1323/remove-all-hyperlinks-in-word-or-excel/ -
Subscribe
All Comments -
Community
-
Top Commenters
-
davak
83 comments · 1 points
-
danishbacker
9 comments · 1 points
-
flexinfo
11 comments · 1 points
-
bej
4 comments · 1 points
-
dimithri
5 comments · 1 points
-
-
Popular Threads
-
Windows 7: How to Prevent the Mouse from Waking your PC
1 week ago · 2 comments
-
Outlook 2010: Turn Off Attachment Preview
2 weeks ago · 2 comments
-
Gmail: How to Send SMS Messages Without Using Email
3 weeks ago · 2 comments
-
Thunderbird 3: How to Download Images Automatically
2 weeks ago · 1 comment
-
Windows 7 – Prevent Live Messenger from Opening at Start Up
2 weeks ago · 1 comment
-
Windows 7: How to Prevent the Mouse from Waking your PC
Have been attempting to find a solution for some time.
This macro cleared all links in a very large file at the first attempt.
Dehkay
very very nice.. was so easy with your help
gurinder singh
I ran the above macro during a term paper that i was working on, in MS Word 2007.
Works great - removed all the hyperlinks....
Thanks ALOT!!
Thanks
,Controls from the Drawing toolbar,Pictures, chartsactive x,buttons,pcitures,drop down lists etc.It will basically remove all these objectsActiveX controls. even cell comments but not cell comments
Code:
Sub Shapes1()
'Delete all Objects except Comments
On Error Resume Next
ActiveSheet.DrawingObjects.Visible = True
ActiveSheet.DrawingObjects.Delete
On Error GoTo 0
End Sub
Super huge thanks
Thank you so much.
Made my life a whole lot easier. =D
Didn't know I'd ever FIND it, just by googling. Congrats. GREAT CODE!
Thanks
tks
I found yet another way, just select some normal text in the paragraph and click the Format Painter. Then select all the text where you want hyperlinks removed. The text retains most of the formatting (except when it disagrees with the original text selected before clicking Format Painter).
thanks dear
u rock
this is excellant
Is there a way where you can can keep the hyperlinks in one column that you want .. and remove it from the rest of the sheet?
----
There's another tip that says to select all text and clear formatting. But this makes it lose formatting.
I found yet another way, just select some normal text in the paragraph and click the Format Painter. Then select all the text where you want hyperlinks removed. The text retains most of the formatting (except when it disagrees with the original text selected before clicking Format Painter).
----
As for Excel, you can try the second way there too! Just select a cell with normal text, then click (or double-click if you want to do multiple times) the Format Painter, then select the columns with hyperlink that you want removed. Remember that all the selected columns will have the same formatting as the original cell you selected.
Well apparently I discovered that in both Word and Excel, it doesn't actually remove the hyperlink but only make the formatting of the link similar to the normal text you selected. This means the links no longer look like links anymore (it looks like normal text now), but when you click on it, it still launches your browser to navigate to the link address.