Cell interpreted as mailto

[Walter Briscoe]

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?

 

[zvkmpw]

How do I stop Excel interpreting cells

as hyperlinks? I found nothing obvious in Tools\Options.

Tools > AutoCorrectOptions > AutoFormatAsYouType > Replace as you type

 

[Walter Briscoe]

In message <[email protected]> of
Thu, 14 Jun 2012 14:23:01 in microsoft.public.excel.worksheet.functions,

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.

 

[GS]

Walter Briscoe formulated the question :

In message <[email protected]> of
Thu, 14 Jun 2012 14:23:01 in microsoft.public.excel.worksheet.functions,


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

 

[Walter Briscoe]

In message <[email protected]> of Fri, 15 Jun 2012 08:53:27 in

Walter Briscoe formulated the question :

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.

 

[GS]

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