Excel URL's

[Don Niall]

I'm reposting this message as the recommended action
didn't work, and I cannot reply to his post ...
==========================================================
Hi,

If I have an Excel s/s that contains multiple fields with
live URL links, is there a way to deactivate the link? I'm
working with such a s/s presently, and its frustrating as
I inadvertently trigger URL links constantly!!

 

[Tom Ogilvy]

Public Sub DeleteHyperlinks()
ActiveSheet.Hyperlinks.delete
End Sub

 

[Andy B]

Don

Copy a blank cell. Then Paste/Special/Add. This undoes the hyperlink.

Andy.