Mass Remove Hyperlinks

  • Thread starter Thread starter Bojhan
  • Start date Start date
B

Bojhan

Hello,

I want to remove 1200 Hyperlinks, is it possble to do it mass?

Regards,

Bojhan:confused
 
One way:

Type ALT-F11 to enter the Visual Basic Editor. Choose View/Immediate
Window. In the Immediate Window, type or paste

Cells.Hyperlinks.Delete

and hit Enter. Type ALT-F11 to return to XL.
 
another
Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub
 
These may help you with macros
http://www.mvps.org/dmcritchie/excel/getstarted.htm
http://www.st-andrews.ac.uk/ITS/faq/excel/mac1.html
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=302
http://homepages.ius.edu/WCLANG/vbnotes/vbnotes.htm

The one you want to use is here
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperlinks

Or if you want one which someone has already made download ASAP utilities,
it is free, from here and highly recommended.
http://www.asap-utilities.com/
and use ASAP utilities (it appears on the menu when installed), web, remove
all hyperlinks in selected cells.

Barbara
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

changing hyperlinks 1
Macro repairing links in hyperlink 1
Open specific hyperlink (accept) automatically in email with outlook 0
Hyperlink formatting 2
Center of Mass 3
Hyperlinks 1
How to prevent email addresses from becoming hyperlinks, and removinghyperlink 1
Will not auto open .jpg 1

Back
Top