sending emails from adresses in cells?

B

BerkBrian

I want to disable the feature in excel where you can send an email by
touching an email address in an Excel cell. How do I do this?
Thanks1
 
R

Ron de Bruin

Hi

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 '

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
 
Top