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.
#2 right lick on the selected range of cells, select Remove Hyperlinks from the drop-down menu list.
#3 you will see that all hyperlinks in the selected range of cells have been removed.
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.
#2 then the “Visual Basic Editor” window will appear.
#3 click “Insert” ->”Module” to create a new module.
#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:
Sub RemoveAllHyperlinks() ActiveSheet.Hyperlinks.Delete End Sub
Remove all hyperlinks in the selected range, you can use the following VBA code:
Sub RemoveSelectedHyperlinks() Selection.Hyperlinks.Delete End Sub
#5 back to the current worksheet, then run the above excel macro. Click Run button.
#6 Let’s see the result: