Delete all hyperlinks on a sheet

Open your Excel spreadsheet that you wish to remove the hyperlinks from. Press ALT-F11 to go to the Visual Basic editor. Create a new module. You can do this by selecting Module under the Insert menu.

Paste the following code into your new module:

Sub RemoveHyperlinks()

‘Remove all
hyperlinks from the active sheet

ActiveSheet.Hyperlinks.Delete

End Sub

Close the Visual Basic editor window by selecting “Close and Return to Microsoft Excel” under the File menu.

September 28, 2007 | Filed Under Tech | Leave a Comment 
Your Ad Here