To remove multiple hyperlinks
Solved
Hello,
I have a column of emails that are hyperlinked. I have 8000.
When I right-click on the cell, I click "Remove Hyperlink" and it works well.
However, when I try to do it for the entire column, I no longer have the option to remove it.
Do you have any idea how we can do it quickly?
Thank you
Configuration: Windows 7 / Firefox 10.0.2
I have a column of emails that are hyperlinked. I have 8000.
When I right-click on the cell, I click "Remove Hyperlink" and it works well.
However, when I try to do it for the entire column, I no longer have the option to remove it.
Do you have any idea how we can do it quickly?
Thank you
Configuration: Windows 7 / Firefox 10.0.2
9 answers
-
ModeratorHello,
8000 links to delete!! Good luck...
Here’s a method to remove all hyperlinks from a pre-selected range:
1- Open your Excel workbook, ;-)
2- Press ALT+F11
3- Insert/Module
4- In this module, copy-paste this code:Sub ClearLinks() With Selection .Hyperlinks.Delete End With End Sub
5- Close the Visual Basic window to return to your sheet,
6- Select your column,
7- ALT+F8, choose: ClearLinks click on Run
8- Nothing for 8, it's done
--
Best regards,
Franck P
