software

spreadsheet column contains email addresses, which change color as soon as I
finish.. if I try to click on the cell to edit it.. it thinks I want to send
mail to that address and opens my email program..

very frustrating and can't find any way to turn this off..
help!


NSK Wrote:
gt; spreadsheet column contains email addresses, which change color as soon
gt; as I
gt; finish.. if I try to click on the cell to edit it.. it thinks I want to
gt; send
gt; mail to that address and opens my email program..
gt;
gt; very frustrating and can't find any way to turn this off..
gt; help!

move mouse on the cell,right click mouse and select quot;cancel
hyperlinkquot;. It's OK.

rgds
LC--
lc_shi
------------------------------------------------------------------------
lc_shi's Profile: www.excelforum.com/member.php...oamp;userid=32393
View this thread: www.excelforum.com/showthread...hreadid=521605Actually if you are going to edit the cell you would be best doing it
from the Edit hyperlink where you see everything if they are object hyperlinks,
which can be invoked by Ctrl K if you are already at the cell...

If you want to select the cell for other reason and not take the hyperlink, there
are several things you can do
click, wait a second then release
select an adjacent cell then arrow into to cell

Avoiding taking the hyperlink when selecting a cell (#avoiding)
www.mvps.org/dmcritchie/excel...c.htm#avoiding

If you want remove hyperlinks with a macro, directions on same page.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;lc_shiquot; gt; wrote in message
...
gt;
gt; NSK Wrote:
gt; gt; spreadsheet column contains email addresses, which change color as soon
gt; gt; as I
gt; gt; finish.. if I try to click on the cell to edit it.. it thinks I want to
gt; gt; send
gt; gt; mail to that address and opens my email program..
gt; gt;
gt; gt; very frustrating and can't find any way to turn this off..
gt; gt; help!
gt;
gt; move mouse on the cell,right click mouse and select quot;cancel
gt; hyperlinkquot;. It's OK.
gt;
gt; rgds
gt; LC
gt;
gt;
gt; --
gt; lc_shi
gt; ------------------------------------------------------------------------
gt; lc_shi's Profile: www.excelforum.com/member.php...oamp;userid=32393
gt; View this thread: www.excelforum.com/showthread...hreadid=521605
gt;