7. VBA tips - remove Hyperlinks
Hyperlinks can be like mosquitoes
- Sometimes you can't see them and they get you when you're least expecting.
The reason is that even if you clear the contents of a cell, the hyperlink can remain. Time to blast them with a bit of VBA. It's easily done... Hyperlinks are stored on a sheet by sheet basis, so all you have to do is to loop through the hyperlinks collection of the active sheet and delete them.
For Each theHyperlink In ActiveSheet.Hyperlinks theHyperlink.Delete Next
Sub RemoveHyperlinks() For Each theHyperlink In ActiveSheet.Hyperlinks If theHyperlink.Range.Value = "" Then theHyperlink.Delete End If Next End Sub
Here's a screen shot of our example file:
Training Video on how to remove Hyperlinks: