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 · 11 months ago

Also by presssing Ctrl + 6 we can do this!

Will · 12 months ago

Wow, very helpful! Thank you!

gurinder · 12 months ago

thanks ...

very very nice.. was so easy with your help

gurinder singh

agun · 11 months ago

owo great .... thank u ...

Shivshanker Cheral · 11 months ago

you can remove hyperlink using Ctrl+6 also

Nishant · 11 months 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 · 10 months ago

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

Blandoo · 10 months 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 · 6 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 · 10 months ago

Worked like a charm for removing all hyperlinks - thanks

sil · 10 months ago

Many Thanks for this help, Muchly appreciated

me · 9 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 · 9 months ago

it's really very good

Dan · 9 months ago

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

orpheus · 9 months ago

Thank you very much. It's very useful.

tabi · 8 months ago

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

CasuaL · 7 months ago

Great work, thanks a lot :)

Bob · 7 months ago

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

Sridhar · 7 months ago

Marvellous

Jason · 6 months ago

Damn Nice!
Thank you so much.

sasikanth · 6 months ago

it nice it working thanks

prasad · 6 months ago

very very very very very thanks

Johnny · 6 months ago

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

Anji · 6 months ago

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

k · 6 months ago

gr8! saves me a lot of time.

Andy McDandy · 5 months ago

Thanks a lot..great help

Prashanth · 4 months ago

just copy to notepad and paste it back!

adam · 4 months ago

I have been ALWAYS looking for this.

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

ivica · 4 months ago

TNX

nox13666 · 4 months ago

Thanks, this worked

vm0430 · 3 months ago

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

Kevin · 2 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 · 1 month ago

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

Heather · 2 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 · 2 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 · 1 month ago

yes its also working good
thanks dear

Vanessa · 1 month ago

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

rickd24 · 1 month ago

Adding another thank you to the list!

senthilds08 · 1 month ago

Very Very Thanks

Jay · 5 days ago

Thank You, this worked like a dream.

Website

Original page

Subscribe

Community

Top Commenters

Popular Threads

Tech-Recipes: Remove All Hyperlinks in Word or Excel | Microsoft Office | Tech-Recipes