Can Remove Hyperlinks

[sayme]

How can I stop excel from making a cell clickable if I got an email address in it? I keep opting for "remove hyperlink". But when I click back in it it becomes a hyperlink again and it becomes clickable. I tried formatting it as "general" or "text" but that doesnt work. ANy help will do.

 

[Logit]

.
I notice here that it only becomes a hyperlink again if the cell is DOUBLE CLICKED.

A single click does not re-create the hyperlink.

You could also paste this small macro into the sheet level module. Right click the sheet tab where the hyperlink is located, select VIEW CODE.
Paste this macro in large white window on the right :

Option Explicit


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Range("F5").Hyperlinks.Delete
End Sub

Change the cell reference "F5" to match the cell location on your sheet.

 

[thisoldman]

Try File >> Options >> Proofing
Click on the button labeled "AutoCorrect Options..."
On the tab labeled AutoFormat as You Type", uncheck the option "Replace as you type :: Internet and network paths with hyperlinks".
OK your way out.

 

[sayme]

.
You could also paste this small macro into the sheet level module. Right click the sheet tab where the hyperlink is located, select VIEW CODE.
Paste this macro in large white window on the right :

Option Explicit


Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    Range("F5").Hyperlinks.Delete
End Sub

The beauty of VBA. Actually i used thisoldman's way. Thanks anyway partner!

Change the cell reference "F5" to match the cell location on your sheet.

Try File >> Options >> Proofing
Click on the button labeled "AutoCorrect Options..."
On the tab labeled AutoFormat as You Type", uncheck the option "Replace as you type :: Internet and network paths with hyperlinks".
OK your way out.

Perfect! Thank you.

 

[Logit]

You are welcome.

 

[sayme]

You are welcome.

ok no prob