Excel & hyperlinks

[Guest]

How do I opt out of the automatic creation of hyperlinks in
Excel? I know how to remove them once they are created,
but I don't want to have to do that. Instead, I want the
default to be that Excel just treats it as text, and not a
URL or email address. How do I do that? Thanks.

 

[Norman Harker]

Hi!

For XL2002/2003 you can turn this feature off in Tools/Autocorrect.

For other versions, see JE's instructions:

http://www.mcgimpsey.com/macoffice/excel/nohyperlinks.html

and

http://www.mcgimpsey.com/macoffice/excel/nohyperlinks2.html


He's written from a MacXL perspective, but the concepts translate
easily to WinXL.

Perhaps, the easiest way is to precede the entry with an '


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[Jim]

Thanks for the help!

-----Original Message-----
Hi!

For XL2002/2003 you can turn this feature off in Tools/Autocorrect.

For other versions, see JE's instructions:

http://www.mcgimpsey.com/macoffice/excel/nohyperlinks.html
http://www.mcgimpsey.com/macoffice/excel/nohyperlinks2.html


He's written from a MacXL perspective, but the concepts translate
easily to WinXL.

Perhaps, the easiest way is to precede the entry with an '


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.



.

 

[Norman Harker]

Hi Jim!

It's JE and Ron de Bruin who should be thanked here!

I knew that this was recently covered and did a Google Search using
Ron de Bruin's Google Search tool and found a recent posting by JE.

For Ron's extremely useful and user friendly search tool, pay a visit
to:

Ron de Bruin
http://www.rondebruin.nl/Google.htm

Google Search 6.0 has now been released and is a great improvement on
the older versions. Indeed, as I write, there have been a couple of
additional changes made. The user Guide is still the old Google Search
5.0 one but the Version 6.0 is getting towards completion. However,
the tool is pretty intuitive and the Guide is really only needed for
beginners and those with problems.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[David McRitchie]

Hi Jim,
I personally find it a lot easier to just let then get created then run
a macro to eliminate the hyperlinks from the selection area(s).
This way if you actually want them they aren't automatically removed.
The other methods do nothing to stop them from being created they
simply remove them once created.

Build Table of Contents, similar listings, working with Hyperlinks
Removing object hyperlinks from a Cell or cell range (#DelHyperlinks)
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperLinks,

Use of a single name as an anonymous poster or different names
in postings and replies, and from one thread to another will not help
you find your postings and threads later on in the newsgroups archives
Even with two names before the anonymous portion, there may be
others with the same fake email address, but at least it will narrow
the range in finding your own postings and their threads.
http://www.mvps.org/dmcritchie/excel/xlnews.htm