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?
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?
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" <[email protected]> wrote in message
news:[email protected]...
>I am using Excel for a simple database. One column contains
> 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?
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" <[email protected]> wrote in message
news:[email protected]...
>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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks