How to remove hyperlink in Excel VBA?

We can remove hyperlink from cell using removehyperlinks method. This method removes the hyperlink from the cell, but doesn’t change the value of the cell. However, the cell’s formatting should be set to the same as before to get the desired effect. You can also use this method to remove hyperlinks in worksheets, charts, table, and named ranges.

How to remove hyperlink from excel without changing the value

If you just want to remove hyperlink from Excel without changing the value, you can use the Remove Hyperlinks option in the Properties window. To do that, right click on the cell where you want to remove hyperlink, click on the cell’s Format menu and then choose Properties. In the Properties window, locate the Hyperlinks tab and remove the check mark from the item “Remove Hyperlink”.

How to remove hyperlink in Excel VBA without showing hyperlink?

Sometimes, while running VBA codes, we get a hyperlink displayed in the cell of Output. This hyperlink will only be shown, but not in the cell itself. We can remove the hyperlink without showing it in the output cell using a simple VBA code. All we need to do is use the following line:

How to remove hyperlink in excel without changing cell value?

To remove hyperlink in excel without changing cell value, use the below VBA code. It doesn’t change or affect the cell value. Just remove the hyperlink.

How to remove hyperlink in Excel without changing original value?

As mentioned above, the hyperlinks in Excel can be removed by removing the hyperlink property. But, if you change the value of the cell to the text, then the hyperlink is lost. To prevent this issue, you can replace the hyperlink with the text and copy the cell value.