Saturday, March 20, 2010

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 
Creative Commons License 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/.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...