Excel: Delete All Hyperlinks from Excel Worksheet

Hit [ALT]+[F11] to open the Visual Basic Editor

Go to “Insert” > “Module” and in the pop-up window copy:

Sub RemoveHyperlinks()
'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete
End Sub

Then click “File” > "Close and return to Microsoft Excel"

You can now run the Macro in Excel by going to:

Developer* > Macros > and then Run “RemoveAllHyperlinks”, this will delete all URLS on the selected worksheet.

Big thanks! to Tech-Recipes

*If the "Developer" tab is not showing in your ribbon, here is how to get it to display 

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivs 3.0 Unported License. This post has been scraped in violation of that license if you are reading this post on other than http://www.digital-qa.blogspot.com/.