Stop launching outlook when I click on an email address?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dagmaer - 21 Aug 2007 18:44 GMT

I would like excel to ignore email addresses, and stop launching my email
program when I click on a cell containing an email address. I would like to
apply this setting to everything I do in excel if possible, rather than
applying it to each worksheet or cell.

Reply to this Message

Ron de Bruin - 21 Aug 2007 19:08 GMT

Hi Dagmaer

In Excel 2002 and up you can turn this off

Tools>AutoCorrect options
See the Autoformat as you type tab

In Excel 2007 :

Office buttton
Excel options
Proofing
Autocorrect options
Autoformat as you type tab

In older version you can do this
You can also start with a ' when you start typing
Or use Ctrl z after you enter

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

>I would like excel to ignore email addresses, and stop launching my email
> program when I click on a cell containing an email address. I would like to
> apply this setting to everything I do in excel if possible, rather than
> applying it to each worksheet or cell.

Reply to this Message

Dagmaer - 21 Aug 2007 19:40 GMT

This appears to only work for the spreadsheet I have open. "Autocorrect
options" is not available if I do not have a spreadsheet open, and the
setting does not appear to be carrying over to the next spreadsheet.

Also, existing email addresses (addresses I have already entered into cells)
are still acting like hyperlinks, and are launching Outlook. This in spite of
the fact that I converted all of the '@' symbols to " [at] ".

I am using MS Office Excel 2003, if that is helpful.

> Hi Dagmaer
>
[quoted text clipped - 19 lines]
> > apply this setting to everything I do in excel if possible, rather than
> > applying it to each worksheet or cell.

Reply to this Message

Ron de Bruin - 21 Aug 2007 20:16 GMT

It is a Application setting but only working if you enter new mail or url addresses in existing and new workbooks.

For existing links you can use a macro to remove the links

Sub test()
ActiveSheet.Hyperlinks.Delete
End Sub

Alt-F11
Insert>Module from the menubar
paste the sub in there
Alt-Q to go back to Excel

If you do Alt-F8 you get a list of your macro's
Select "test" and press Run

Signature

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm

> This appears to only work for the spreadsheet I have open. "Autocorrect
> options" is not available if I do not have a spreadsheet open, and the
[quoted text clipped - 29 lines]
>> > apply this setting to everything I do in excel if possible, rather than
>> > applying it to each worksheet or cell.

Reply to this Message

Dagmaer - 21 Aug 2007 21:58 GMT

Thank you! Other than removing some formatting (easy to fix), this worked
perfectly.

> It is a Application setting but only working if you enter new mail or url addresses in existing and new workbooks.
>
[quoted text clipped - 45 lines]
> >> > apply this setting to everything I do in excel if possible, rather than
> >> > applying it to each worksheet or cell.

Reply to this Message