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/.
0 comments:
Post a Comment