How to remove all hyperlinks in an Excel file

Looking to remove all the hyperlinks in an Excel file?

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:

Tools > Macro > Macro and then Run “RemoveAllHyperlinks”, this will delete all URLs on the selected worksheet.

This entry was posted in Macros. Bookmark the permalink. Post a comment or leave a trackback: Trackback URL.

2 Comments

  1. Trish
    Posted January 11, 2015 at 8:43 am | Permalink

    Thank you – easiest solution by far

    • karen
      Posted January 22, 2015 at 4:51 pm | Permalink

      Thank you, Trish! 🙂

Post a Comment

Your email is never published nor shared. Required fields are marked *

You may use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*
*