Excel: "De-activating" an e-mail address cell?

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

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" <HowdyPete@discussions.microsoft.com> wrote in message news:9EB117A6-8583-48A9-926C-9A1B47841514@microsoft.com...
> 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.