Is this a hyperlink assigned to the textbox or the value of the text in the
textbox?

I put a textbox from the Drawing toolbar on a worksheet and rightclicked on it
and assigned it a hyperlink.

Then this would delete the hyperlink:

Dim TBox As TextBox
Set TBox = ActiveSheet.TextBoxes("Text Box 1")
'in case there isn't a hyperlink
On Error Resume Next
TBox.ShapeRange.Item(1).Hyperlink.Delete
On Error GoTo 0

Jarle wrote:

I have a hyperlink in a textbox. How can I delete this hyperlink with vba code.

I have tried

Worksheets(1).Shapes("txtbox1").Hyperlinks.Delete

and similar code, but this doesn't work. Can anyone help?

Thank you

rgds
Jarle

--

Dave Peterson