deactiving a group of hyperlinks

[sme]

Hi,

I've copied in a list of email addresses into Excel, but
I want to deactive the automatic hyperlink.

I know how to deactive one by one by one ...

Is there a way to deactive all in a selected range? Or
shutoff the option?

TIA

 

[pfsardella]

John Walkenbach has a spiel with a macro to do this.

http://j-walk.com/ss/excel/usertips/tip031.htm

Sub ZapHyperlinks()
'Cells.Hyperlinks.Delete '' does all hyperlinks
Selection.Hyperlinks.Delete '' does only those selected
End Sub

HTH
Paul

 

[J.E. McGimpsey]

See my reply to your later post.