Hyperlinks

[Candace Sanhez]

Is there a way in excel to turn off the hyperlink feature for an entire
column of data? I have a column of email addresses, and I don't want any of
them to be an active hyperlink. I can remove the hyperlink individually,
but have not been able to find a way to do it for the entire column of data.

Thanks!

 

[Gord Dibben]

Candace

A small macro will remove any existing hyperlinks.

Sub Delete_HLinks()
For Each cel In Selection
cel.Hyperlinks.Delete
Next cel
End Sub

To prevent future hyperlinks for the entire sheet go to Tools>Autocorrect
Options>AutoFormat as you type.

Un-select "Replace as you type" for internet addresses etc.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

And I think you can remove all the hyperlinks in one fell swoop <bg>.

Sub Delete_HLinks()
Selection.Hyperlinks.Delete
End Sub

 

[Gord Dibben]

Thanks Dave.

Always a faster way.


Gord

And I think you can remove all the hyperlinks in one fell swoop <bg>.

Sub Delete_HLinks()
Selection.Hyperlinks.Delete
End Sub

Gord Dibben MS Excel MVP

 

[redruthann]

YOU ARE THE BEST!

I've been struggling with this for a while. Just like Candace, I needed to
remove several pastes hyperlinks, but I do not want to turn them off
completely, So Thank You Very Much

Ruth
No Reply Needed

 

[Dave Peterson]

Glad you got it working the way you want.

YOU ARE THE BEST!

I've been struggling with this for a while. Just like Candace, I needed to
remove several pastes hyperlinks, but I do not want to turn them off
completely, So Thank You Very Much

Ruth
No Reply Needed