B
Bojhan
Hello,
I want to remove 1200 Hyperlinks, is it possble to do it mass?
Regards,
Bojhan:confused
I want to remove 1200 Hyperlinks, is it possble to do it mass?
Regards,
Bojhan:confused
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
F
Frank Kabel
B
Bojhan
sorry, but I'm a real newbie in these kinds of codes:confused
J
JE McGimpsey
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.
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.
D
Don Guillett
another
Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub
Sub HyperlinksOut()
ActiveSheet.Hyperlinks.Delete
End Sub
W
wiseman
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
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