Sub RemoveHyperlinks() 'Remove all hyperlinks from the active sheetActiveSheet.Hyperlinks.Delete End Sub Close the Visual Basic editor window by selecting "Close and Return to Microsoft Excel" under the File menu. run Macro under tools/macro
Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheetActiveSheet.Hyperlinks.Delete
End Sub