Remove Hyperlink From Text Or Object. Of course this is assuming you dont want any HTML to be allowed in the text box. Resume Next End Sub.
The below image I had created a hyperlink on a NAME column. Calling the Delete method on the specified Hyperlinks object is equivalent to using both the Clear Hyperlinks and Clear Formats commands from the Clear drop-down list in the Editing section of the Home tab. This will remove the hyperlink in excel as well.
Of course this is assuming you dont want any HTML to be allowed in the text box.
String GoodInputBadInputReplace. There are two ways you can remove all hyperlinks in a particular sheet. Ie hyperlink with underline Step 4. You will get a prompt shown below asking if you are sure you want to break the links as this action is irreversible.