Prevent e-mail entrys from linking

[Michael Lanier]

I have need for entering multiple e-mails in a worksheet. While all
automatically link, there are places where I do not want the links to
take place--ever. Is there a way to prevent links in designated
cells? Also, the cells are merged if that makes a difference. Thanks
in advance.

Michael

 

[Shane Devenshire]

Hi,

right click and choose remove hyperlink.

or for more than one cell - click an empty cell choose copy, select all the
hyperlinks you want removed and choose Edit, Paste Special, Add.

 

[Michael Lanier]

Shane,

The only problem is that when I enter another e-mail address later, it
too once again links. I'm hoping to unlink the applicable cell once
and for all without affecting other cells within the workbook. Thanks
for your help.

Michael

 

[Shane Devenshire]

Hi,

Your option is a VBA macro.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim isect As Range
Application.EnableEvents = False
Set isect = Application.Intersect(Target, Range("A1,C1"))
If Not isect Is Nothing Then
[IV65536].Copy
Target.PasteSpecial Paste:=xlPasteAll, Operation:=xlAdd
End If
Application.EnableEvents = True
End Sub

 

[Shane Devenshire]

Hi,

I should add - The code goes into the sheet object in the VBE:

1. To add this code to your file, press Alt+F11,
2. In the VBAProject window, top left side, find your sheet name under your
file name and double click it.
3. Paste in or type the code above.

 

[Michael Lanier]

Thanks Shane. I'll be giving it a try tomorrow. Regarding a "Yes"
button, there is none to be found on my screen. If it's in a
different location, please let me know and I'll be happy to comply.

Michael