DISQUS

Hello! Tech-Recipes is using DISQUS, a powerful comment system, to manage its comments. Learn more.

Community Page

www.tech-recipes.com/ Jump to website »

Subscribe
- New Comments
Community
Top Commenters
- davak
  76 comments · 1 points
- shamanstears
  26 comments · 1 points
- Quinn McHenry
  23 comments · 2 points
- seamonkey420
  18 comments · 1 points
- flexinfo
  11 comments · 1 points
Popular Threads
- Firefox 3.5: How to Disable Location-Aware Browsing
  17 hours ago · 1 comment
- Using iPhone 3G S Voice Control Commands
  1 week ago · 7 comments
- iPhone 3.0: Show Battery Percentage
  1 week ago · 7 comments
- Windows 7: How to Reset the Recycle Bin
  6 days ago · 1 comment
- Windows 7: Make Aero Perform Faster
  2 weeks ago · 2 comments
Recent Comments
- Thanks mate, Just what I was looking for. It seemed to be a different way of doing things in Leopard than previous versions. Cheers, Mitch
  29 minutes ago by Mitch
  
  in OS X: Change your PATH environment variable | Mac system administration | Tech-Recipes
- thanks, i couldnt remember.
  1 hour ago by Goddo
  
  in XP/Vista: View and change the computer name, domain, and workgroup settings | Windows | Tech-Recipes
- I did this in Garage band, but if forced me to trip the song to 8 seconds in order to send it to itunes ringtones - any ideas on this? Using the new 3GS.
  1 hour ago by dofo
  
  in iPhone: How to Create Free Ringtones | Apple iPhone | Tech-Recipes
- Please dont remove this Folder, It occupies only 315 MB and is useful for your Office 2003.... SRIKANTH
  3 hours ago by SRIKANTH
  
  in XP: What is the Msocache Folder and How to Remove It | Microsoft Office | Tech-Recipes
- that still wont work and i got no idea about registery could use help
  5 hours ago by help
  
  in Clear Windows DNS Cache | Windows | Tech-Recipes

Tech-Recipes

Cookbook of Tech Tutorials

Jump to original thread »

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

Started by qdideas · 9 months ago

No excerpt available. Jump to website »

35 comments

Dehkay
8 months 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

reply

fhff
8 months ago

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

reply

James
8 months ago

very nice! thanks for the tip!

reply

Scott
8 months ago

THANK YOU! 1 Million ties thank you!!

reply

Umer
8 months ago

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

reply

Student
8 months ago

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

reply

Shivshanker Cheral
7 months ago

Also by presssing Ctrl + 6 we can do this!

reply

Will
7 months ago

Wow, very helpful! Thank you!

reply

gurinder
7 months ago

thanks ...

very very nice.. was so easy with your help

gurinder singh

reply

agun
7 months ago

owo great .... thank u ...

reply

Shivshanker Cheral
7 months ago

you can remove hyperlink using Ctrl+6 also

reply

Nishant
6 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!!

reply

john
6 months ago

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

reply

Blandoo
6 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

reply

Najen
2 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

reply

Rusty
6 months ago

Worked like a charm for removing all hyperlinks - thanks

reply

sil
6 months ago

Many Thanks for this help, Muchly appreciated

reply

me
5 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

reply