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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clicking on cell with email address opens Outlook Express 2
Excel Unlink open excel files 2
Excel Spreadsheets keep moving 0
How do I stop Excel opening up my PDF documents 2
Excel How to Fix Damaged Excel File That Won't Open? 3
E-Mail Issue in Excel 5
Red cell for negative numbers in Excel 1
Stop launching outlook when I click on an email address? 4

Back
Top