Remove Hyperlinks

This post will guide you how to remove all hyperlinks from Excel worksheet. How do I quickly remove all unwanted hyperlinks from an excel worksheet with VBA code. How to remove or delete multiple hyperlinks in a worksheet at once.

Remove Hyperlinks with Remove Hyperlinks Command


If you want to remove all or multiple hyperlinks in your worksheet, you can use the Remove Hyperlinks command in Excel 2010 or newer version to achieve the result. Let’s see the below detailed steps:

#1 Select the range of cells that contain hyperlinks that you want to remove.

remove hyperlinks1

#2 right lick on the selected range of cells, select Remove Hyperlinks from the drop-down menu list.

remove hyperlinks2

#3 you will see that all hyperlinks in the selected range of cells have been removed.

remove hyperlinks3

Remove Hyperlink with VBA code


You can also use the VBA Macro code to quickly delete or remove all hyperlinks in your current worksheet or just only the selected range of cells. You just need to refer to the following steps:

#1 open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.

Get the position of the nth using excel vba1

#2 then the “Visual Basic Editor” window will appear.

#3 click “Insert” ->”Module” to create a new module.

convert column number to letter3

#4 paste the below VBA code into the code window. Then clicking “Save” button.

Removing all hyperlinks in your current worksheet, you can use the following VBA code:

remove hyperlinks4

Sub RemoveAllHyperlinks()
    ActiveSheet.Hyperlinks.Delete
End Sub

Remove all hyperlinks in the selected range, you can use the following VBA code:

remove hyperlinks4-1

Sub RemoveSelectedHyperlinks()
 Selection.Hyperlinks.Delete
End Sub

#5 back to the current worksheet, then run the above excel macro. Click Run button.

remove hyperlinks5

#6 Let’s see the result:

remove hyperlinks6

 

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar