VBA – Delete Hyperlinks

Delete All Hyperlinks From a Sheet

The following code deletes all of the Hyperlinks from Sheet1:

Sub DeleteHyperLinks()

Sheet1.Hyperlinks.Delete

End Sub

And if you don’t need a reusable Sub routine, rather a one time fix, use the Immediate Window:

1. Select the Sheet to remove Hyperlinks from

2. Press Alt+F11 to open the VBE

3. On the VBE Main Menu choose View->Immediate Window

4. In the Immediate Window paste the following code then hit Enter

ActiveSheet.Hyperlinks.Delete