E-mail Addresses in Excel
 

I am using Excel for a simple database. One column contains e-mail
addresses. When I click on an address, it jump starts Outlook, which I don't
use. I lose a lot of time closing it. Is there some way to turn off the
auto start?

E-mail Addresses in Excel
 

To delete the existing hyperlinks and leave only the email
messages as text, use the following macro:
Sub AAA()
Dim Rng As Range
For Each Rng In Selection.Cells
Rng.Hyperlinks.Delete
Next Rng
End Sub

Select the cells in question and run the code.

To prevent Excel from automatically changing email addresses to
hyperlinks, go to the Tools menu, choose AutoCorrect Options,
then the "AutoFormat As You Type" tab, and uncheck "Internet and
network paths with hyperlinks."


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Kim" wrote in message
...
I am using Excel for a simple database. One column contains
e-mail
addresses. When I click on an address, it jump starts Outlook,
which I don't
use. I lose a lot of time closing it. Is there some way to
turn off the
auto start?

E-mail Addresses in Excel
 

Select the whole range which has email address, then right click your mouse,
then select remove hyperlink.

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"Kim" wrote in message
...
I am using Excel for a simple database. One column contains e-mail
addresses. When I click on an address, it jump starts Outlook, which I
don't
use. I lose a lot of time closing it. Is there some way to turn off the
auto start?