Remove the Hyperlink

[ChrisUK]

Hi.

I have a number of cells which all have hyperlinks in, I'd like to remove the hyperlink and just keep the label part - how can I do this please ?

TIA

Chris

 

[Richard Schollar]

Hi Chris

Copy and paste the following into a standard module in your book, select the cells you want to remove hyperlinks from (doesn't matter if you include cells with no hyperlinks) and activate with Tools>Macro>Macros and run it.

Sub test()
For Each h In Selection.Hyperlinks
    h.Delete
Next h
End Sub

Best regards

Richard

 

[pgc01]

Hi Richard

I was not sure and so I've just checked, and the hyperlinks collection also has the delete method, which is great because the loop is not needed.

Sub test() 
    Selection.Hyperlinks.Delete
End Sub

Kind Regards
PGC

 

[ChrisUK]

That's great thanks, worked a treat!

 

[Richard Schollar]

Pgc01 - that's cool. Makes it a lot faster with loadsa links.

Richard