Excel /VBA - Delete hyperlinks (All versions)

December 2016

A simplemethod to remove all hyperlinks in a selected range:
1 - Open the Excel workbook
2 - Press ALT + F11 (the Visual Basic Editor window opens)
3 - Insert / Module
4 - In the module copy and paste this code:
Sub EraseLinks()
With Selection
End With
End Sub

5 - Close the Visual Basic window to return to the sheet,
6 - Select the range containing all the links,
7 - Press ALT + F8 > select Sub EraseLinks and click on Run.

Related :

This document entitled « Excel /VBA - Delete hyperlinks (All versions) » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.