DISQUS

Dehkay · 1 year ago

Very good.
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

fhff · 1 year ago

Awesome!!!!!!! saved me so much time lol thanks

James · 1 year ago

very nice! thanks for the tip!

Scott · 1 year ago

THANK YOU! 1 Million ties thank you!!

Umer · 1 year ago

Awesome work, after learning such thing, I feel like a geek ;-)

Student · 1 year ago

Select the entire block of text, then press Ctrl-Shift-F9. Presto: No more hyperlinks. In their place, plain text.

Shivshanker Cheral · 1 year ago

Also by presssing Ctrl + 6 we can do this!

Will · 1 year ago

Wow, very helpful! Thank you!

gurinder · 1 year ago

thanks ...

very very nice.. was so easy with your help

gurinder singh

agun · 1 year ago

owo great .... thank u ...

Shivshanker Cheral · 1 year ago

you can remove hyperlink using Ctrl+6 also

Nishant · 1 year ago

Hey
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!!

john · 1 year ago

Very useful to me. Thank you so much :D :D

Blandoo · 1 year ago

Somehow this does not work for javascript embedded within a picture (buttons). Please let me know if there is a "Remove all Javascript" macro I can run.

Thanks

Najen · 8 months ago

Hi here is code to remove all shapes which include objects ActiveX controls (Control Toolbox) or a linked or embedded OLE objects,Controls from the Forms toolbar
,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

Rusty · 1 year ago

Worked like a charm for removing all hyperlinks - thanks

sil · 1 year ago

Many Thanks for this help, Muchly appreciated

me · 11 months ago

ok.. it works... thanks a lot.. i've been loocking for this.. just not hard enough until now because i didn't have that much text copied.. it actually took me 2 minutes to find this... and it's great.. and u actually don't need to know anything.. just follow the easy instructions

shabi · 11 months ago

it's really very good

Dan · 11 months ago

In Office 07 for words. The macro section is under the "view tab" to the far right.

orpheus · 10 months ago

Thank you very much. It's very useful.

tabi · 10 months ago

This didn't work for me...maybe a problem with Excel 2007? Or my stupidity, it's tough to say.

CasuaL · 9 months ago

Great work, thanks a lot :)

Bob · 9 months ago

Excellent - saved me having to remove 700+ hyperlinks by hand.
Super huge thanks

Sridhar · 8 months ago

Marvellous

Jason · 8 months ago

Damn Nice!
Thank you so much.

sasikanth · 8 months ago

it nice it working thanks

prasad · 8 months ago

very very very very very thanks

Johnny · 7 months ago

Thank you very much.
Made my life a whole lot easier. =D

Anji · 7 months ago

THANKS that's great! Saved me precious time. Worked on my mac too.

k · 7 months ago

gr8! saves me a lot of time.

Andy McDandy · 7 months ago

Thanks a lot..great help

Prashanth · 6 months ago

just copy to notepad and paste it back!

adam · 6 months ago

I have been ALWAYS looking for this.

Didn't know I'd ever FIND it, just by googling. Congrats. GREAT CODE!

ivica · 5 months ago

TNX

nox13666 · 5 months ago

Thanks, this worked

vm0430 · 5 months ago

how to enable hyperlink, after removing it using VB..?

Kevin · 4 months ago

Thank you for your help. This is a command that Microsoft clearly forgot to add. Great job! Although I have written plenty of macros (mostly on Excel, but a few in Word), I was not excited about adding to my already large set of macros... but I'm glad that I did. It works perfectly!

Thanks

senthilds08 · 2 months ago

i need macro programs pls send your macros what u have.
tks

Heather · 3 months ago

God, thank you! This is so clean and direct, without entering a bunch of dummy data to sidestep the problem. Thank you so much.

ADTC · 3 months ago

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).

senthilds08 · 2 months ago

yes its also working good
thanks dear

Vanessa · 3 months ago

OMFG thx u! it works! i am soooo hppy! :D

rickd24 · 2 months ago

Adding another thank you to the list!

senthilds08 · 2 months ago

Very Very Thanks

Jay · 1 month ago

Thank You, this worked like a dream.

bninad · 1 month ago

dude whoever you are
u rock
this is excellant

me · 1 month ago

cool. never used a macro before :)

Si · 1 month ago

THANKS! This was really handy when pasting Wikipedia articles into Word

Pirnima · 4 weeks ago

Thank You So much .. my file size has been reduced by half... Thank you really I have been looking for a solution since 3 years!!

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?

ADTC · 4 weeks ago

That's strange. How do hyperlinks make your file two times bigger? Anyway to selectively remove hyperlinks, I posted the following in a previous comment (2 months ago) for Word:

----
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.

arun_lee · 1 week ago

Thanks for the help. It helped me & saved my time.