Stop launching outlook when I click on an email address?

[Guest]

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.

 

[Ron de Bruin]

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

 

[Guest]

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.

 

[Ron de Bruin]

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


--

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
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

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

 

[Guest]

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.

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


--

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
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

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


--

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.