Help to remove text, Hyper Link Maybe

[rockyw]

I made a Hyper link but then decided not to use it. The text still shows in the cell. I can not delete it, I can not even select the cell. I tried selecting the entire row and it still will not go away. If I select all around it, then hit delete, nothing. What is this? How can I get rid of it? Thanks

 

[T. Valko]

I made a Hyper link but then decided not to use it. The text still shows in the cell. I can not delete it, I can not even select the cell. I tried selecting the entire row and it still will not go away. If I select all around it, then hit delete, nothing. What is this? How can I get rid of it? Thanks

Select the cell in question.
Right click>Remove hyperlink

 

[njimack]

Try right-clicking it, then selecting Remove Hyperlink

 

[rockyw]

I can not even select the cell. When I click on the cell the text jumps, then thats it. I do not even get a right click menu, nothing.

 

[T. Valko]

I can not even select the cell. When I click on the cell the text jumps, then thats it. I do not even get a right click menu, nothing.

Try selecting a nearby cell then use the arrow keys to move to and select the cell in question. Then you should be able to right click>remove hyperlink.

 

[njimack]

Try the following code (replacing A1 with the cell reference in question)

Sub Delete_Hyperlink()
Range("A1").Hyperlinks.Delete
End Sub

 

[rockyw]

no go. I put this in a text box, is that why I can not delete it? If I select several cells around it, I can see an area around the text but can not select it. This is weird.

 

[njimack]

Text box? You said it was in a cell.

Can't you delete the entire textbox? If you're having trouble selecting it, and it's the only object on that sheet, use Edit>GoTo>Special>Objects to select it.

 

[rockyw]

I found this code that removed what ever it was. Thanks for the help.

Sub aaa()
  For i = ActiveSheet.Shapes.Count To 1 Step -1
    ActiveSheet.Shapes(i).Delete
  Next i
End Sub

 

[rockyw]

It started as a text box in a cell, then I could not get rid of it. This code removes shapes? Don't know but it's gone. Thanks.