Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell interpreted as mailto
I run Excel 2003.
I composed a cell with the value 4.6@3 Excel chose to give that text a color of blue, underline it and interpret it as a mailto, so that clicking on it causes my email program to open. I do not want that special action. I changed color to automatic and removed the underline, but the cell is still interpreted as a mailto. I know that prefixing a number with a prime character, causes it to be interpreted as text - where is that documented? - but '4.6@3 is also interpreted as a mailto. How do I stop 4.6@3 being interpreted as a mailto? A reference to a help topic would be best, but I will gladly accept a heuristic. I have answered my own question. The relevant help topic is "Remove a hyperlink" where "Deactivate a single hyperlink" says "Right-click the hyperlink you want to deactivate, and then click Remove Hyperlink on the shortcut menu." I have a supplementary question. How do I stop Excel interpreting cells as hyperlinks? I found nothing obvious in Tools\Options. I will repeat the question already asked in passing, above. Where is the use of prime (') to cause a number to be interpreted as text documented? I think there is a general question there. How do I control special action by Excel on entering a set of characters into a cell? -- Walter Briscoe |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell interpreted as mailto
How do I stop Excel interpreting cells
as hyperlinks? I found nothing obvious in Tools\Options. Tools AutoCorrectOptions AutoFormatAsYouType Replace as you type |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell interpreted as mailto
In message of
Thu, 14 Jun 2012 14:23:01 in microsoft.public.excel.worksheet.functions, zvkmpw writes How do I stop Excel interpreting cells as hyperlinks? I found nothing obvious in Tools\Options. Tools AutoCorrectOptions AutoFormatAsYouType Replace as you type Thank you for that. The "Tools/AutoCorrect Options/AutoFormat As You Type/Replace as you type/Internet and network paths with hyperlinks" checkbox is general.. On checking, I find the change is to Application.AutoCorrect.ReplaceText I will put up with the current behavior which is rarely wrong for me. -- Walter Briscoe |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell interpreted as mailto
Walter Briscoe formulated the question :
In message of Thu, 14 Jun 2012 14:23:01 in microsoft.public.excel.worksheet.functions, zvkmpw writes How do I stop Excel interpreting cells as hyperlinks? I found nothing obvious in Tools\Options. Tools AutoCorrectOptions AutoFormatAsYouType Replace as you type Thank you for that. The "Tools/AutoCorrect Options/AutoFormat As You Type/Replace as you type/Internet and network paths with hyperlinks" checkbox is general.. On checking, I find the change is to Application.AutoCorrect.ReplaceText I will put up with the current behavior which is rarely wrong for me. One way I use is to redefine the 'Style' for 'Hyperlink' and just be careful when clicking/selecting cells that have hyperlink type content. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell interpreted as mailto
In message of Fri, 15 Jun 2012 08:53:27 in
microsoft.public.excel.worksheet.functions, GS writes Walter Briscoe formulated the question : In message of Thu, 14 Jun 2012 14:23:01 in microsoft.public.excel.worksheet.functions, zvkmpw writes How do I stop Excel interpreting cells as hyperlinks? I found nothing obvious in Tools\Options. Tools AutoCorrectOptions AutoFormatAsYouType Replace as you type Thank you for that. The "Tools/AutoCorrect Options/AutoFormat As You Type/Replace as you type/Internet and network paths with hyperlinks" checkbox is general.. On checking, I find the change is to Application.AutoCorrect.ReplaceText I will put up with the current behavior which is rarely wrong for me. One way I use is to redefine the 'Style' for 'Hyperlink' and just be careful when clicking/selecting cells that have hyperlink type content. That is interesting! I recorded a macro and followed the instructions to Remove a style. Remove a style 1.Select the cell ... 2.On the Format menu, click Style. 3.In the Style name box, do one of the following: .... €¢To delete a style entirely, click the style name, and then click Delete. The interesting thing in the recording is: ActiveWorkbook.Styles("Hyperlink").Delete When I enter another cell with action equivalent to: Range("E6").Select ActiveCell.FormulaR1C1 = "3@4" E6 is set, I still get "bubble help" saying mailto:3@4 - Click once to follow. Click and "hold to select the cell." but click once does not follow. I still get a Single Underline and Color blue. That would be a fair compromise. However, when I save the change and reopen the file, the hyperlink style is restored. -- Walter Briscoe |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell interpreted as mailto
Walter Briscoe has brought this to us :
However, when I save the change and reopen the file, the hyperlink style is restored. Interesting! The Styles defs follow with the file (or so is the case with those styles I've set/modified). It's not that I don't want the hyperlink there, just that I don't want the default display. In some cases I just want normal font, whatever color I choose to format to. -- Garry Free usenet access at http://www.eternal-september.org ClassicVB Users Regroup! comp.lang.basic.visual.misc microsoft.public.vb.general.discussion |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
decimal number interpreted as a date | Excel Discussion (Misc queries) | |||
How do I copy a hyperlink in a mailto: to a new cell in Excell? | Excel Discussion (Misc queries) | |||
Hyperlink mailto - ref cell for mail subject | Excel Worksheet Functions | |||
excel CSV is interpreted as HTML | Excel Discussion (Misc queries) | |||
How can I avoid a BLANK cell being interpreted as a ZERO? | Excel Programming |