How to stop opening outlook in excel

  • Thread starter Thread starter bill s
  • Start date Start date
B

bill s

How to stop opening outlook in excel when clicking into a cell that contains
an email address.
 
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
 
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
 
Back
Top