In Excel (2003), I have a roster of people with their contact details,
including e-mail addresses. How do I change the e-mail address cells so that
when one clicks on it, it does not activate e-mail?
Thanks.

Right click and select hyperlink and remove the hyperlink.

"HowdyPete" wrote:

In Excel (2003), I have a roster of people with their contact details,
including e-mail addresses. How do I change the e-mail address cells so that
when one clicks on it, it does not activate e-mail?
Thanks.

Hi HowdyPete

You can run this macro also to make text of all hyperlinks
in your worksheet

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

In 2002/2003 you can turn it of

Tools Options Spelling
Press "AutoCorrect Options" Button
AutoFormat As You Type Tab
Remove Check from "Internet and network paths with hyperlinks"
OK
OK

If you have fill in a address and Enter to confirm you
can use Ctrl-Z to make it text.

Or start with a '




--
Regards Ron de Bruin
http://www.rondebruin.nl



"HowdyPete" wrote in message ...
In Excel (2003), I have a roster of people with their contact details,
including e-mail addresses. How do I change the e-mail address cells so that
when one clicks on it, it does not activate e-mail?
Thanks.