Prevent e-mail entrys from linking

  • Thread starter Thread starter Michael Lanier
  • Start date Start date
M

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
 
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.
 
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
 
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
 
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.
 
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
 
Back
Top