View Single Post
  #2   Report Post  
Ragdyer
 
Posts: n/a
Default

You didn't mention your version, but I'm on a XL97 machine today, so I can't
exactly advise on how some of the newer versions disable this "feature",
which they can do.
An old trick for these older versions was to click into an adjoining cell to
the link, and then use the arrow keys to enter the linked cell, therefore
by-passing the "automatic" activation.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"John Smith" wrote in message
...
In several worksheets I store email addresses but XL insists on making
them links. So, if I ever select the cell, it tries to open Outlook
(which I won't let on my machine), etc. It takes me 30 seconds to get
control back. I've looked everywhere in Options but I haven't found
anything to stop this. My workaround is to type the email address in an
unused cell, then copy it and Paste Special into the target cell with
"values only". What a pain.

Can you gurus please help? By the way, I did look hard and long for
this in earlier posts -- I can't be the only one hassled by this.

Thanks much.