![]() |
sending emails from adresses in cells?
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 |
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 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 "BerkBrian" wrote in message ... 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 |
All times are GMT +1. The time now is 11:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com