| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Email Addresses in a spreadsheet
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Email Addresses in a spreadsheet
NSK Wrote: 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! move mouse on the cell,right click mouse and select "cancel hyperlink". It's OK. rgds LC -- lc_shi ------------------------------------------------------------------------ lc_shi's Profile: http://www.excelforum.com/member.php...o&userid=32393 View this thread: http://www.excelforum.com/showthread...hreadid=521605 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Email Addresses in a spreadsheet
Actually 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) http://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: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "lc_shi" wrote in message ... NSK Wrote: 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! move mouse on the cell,right click mouse and select "cancel hyperlink". It's OK. rgds LC -- lc_shi ------------------------------------------------------------------------ lc_shi's Profile: http://www.excelforum.com/member.php...o&userid=32393 View this thread: http://www.excelforum.com/showthread...hreadid=521605 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make email addresses in a column of cells active links? | Excel Discussion (Misc queries) | |||
| Have problem sending spreadsheet email and losing custom toolbar and macros | Excel Discussion (Misc queries) | |||
| How do I convert email addresses to clickable links? | Excel Discussion (Misc queries) | |||
| email portion of spreadsheet as attachment | Excel Discussion (Misc queries) | |||
| How do I cancel sending a spreadsheet by email? | Excel Discussion (Misc queries) | |||
Linear Mode
