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.

Hi Dagmaer

In Excel 2002 and up you can turn this off

ToolsAutoCorrect 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


"Dagmaer" wrote in message ...
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.

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" wrote:

Hi Dagmaer

In Excel 2002 and up you can turn this off

ToolsAutoCorrect 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


"Dagmaer" wrote in message ...
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.

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


"Dagmaer" wrote in message ...
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" wrote:

Hi Dagmaer

In Excel 2002 and up you can turn this off

ToolsAutoCorrect 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


"Dagmaer" wrote in message ...
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.

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

"Ron de Bruin" wrote:

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


"Dagmaer" wrote in message ...
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" wrote:

Hi Dagmaer

In Excel 2002 and up you can turn this off

ToolsAutoCorrect 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


"Dagmaer" wrote in message ...
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.