How to stop opening outlook in excel

[bill s]

How to stop opening outlook in excel when clicking into a cell that contains
an email address.

 

[JP]

Well, you can stop Excel from automatically converting email addresses
to hyperlinks.

Tools > Options > Spelling > click 'AutoCorrect Options > AutoFormat
As You Type > uncheck 'Internet and network paths with hyperlinks'

--JP

 

[Gord Dibben]

If you want to delete the hyperlinks...........not the contents, run this
macro.

Sub Delete_Hyperlinks()
Dim Cell As Range
For Each Cell In Intersect(Selection, _
Selection.SpecialCells(xlConstants, xlTextValues))
Cell.Hyperlinks.Delete
Next Cell
End Sub

To prevent future hyperlinking see JP's reply.


Gord Dibben MS Excel MVP

On Wed, 23 Sep 2009 12:10:02 -0700, bill s <bill