Function: mailto

[Hopeful Waiter]

I have an Excel worksheet that I was given. All the addresses are
mailto hyperlinks. This is OK when the spreadsheet is complete and
correct, however, when it is being edited, it is a pain. Is there a
way to select all the addresses and turn the hyperlinks off, and then,
when you are finished, turn all the hyperlinks back on? I don't mean
address by address...

Thank you for your time.

 

[Mike Barton]

Drop the following code into a VBA Module.

Sub HyperlinksOff()
Selection.Hyperlinks.Delete
End Sub

Sub HyperlinksOn()
Dim oCell As Range
Dim strTextToDisplay As String

For Each oCell In Selection
If Not IsEmpty(oCell) Then
strTextToDisplay = oCell.Value
oCell.Hyperlinks.Add Anchor:=Selection, Address:=strTextToDisplay
End If
Next
End Sub

Select the range before you run either macro.

Mike Barton

 

[Hopeful Waiter]

Good morning Mike!

Thanks for taking the time to answer. I don't know how to use VBA
Modules (yet), but now I know where to go now. I bet I can figure it
out. Thanks again for your kindness.

Hopeful Waiter