A way to disable automatic hyperlinks?

[Melanie Lynch]

I am trying to idiot-proof a template for someone and I want the cells
to treat email address and URL's as plain text and not make automatic
hyperlinks.

Is there a way to do this in preferences? I know you can go cell by cell
and remove the link (sometimes this works and sometimes it doesn't) but
I don't want to have to undo them cell by cell. I don't want it to
happen at all. I have tried format>cells>text, I have done
preferences>calculations>save external link values to no avail.

There has to be a way to do this. OfficeX in 10.3.9

Melanie

[JE McGimpsey]

Take a look here:

http://www.mcgimpsey.com/excel/removehyperlinks.html

and

http://www.mcgimpsey.com/excel/removehyperlinks2.html

You can download an add-in that adds a No Hyperlinks toggle command to
the Tools Menu, and allows you to choose whether to automatically delete
auto-generated hyperlinks or not. It's still a beta version, but it's
been stable:

ftp://ftp.mcgimpsey.com/excel/nohyperlinks.xla

In article <OXvtq5Ij...@tk2msftngp13.phx.gbl>,

[Paul Berkowitz]

On 7/19/05 2:46 PM, in article
jemcgimpsey-6949...@msnews.microsoft.com, "JE McGimpsey"
<jemcg...@mvps.org> wrote:

> Take a look here:
>
> http://www.mcgimpsey.com/excel/removehyperlinks.html

404 Not Found

This works: <http://www.mcgimpsey.com/macoffice/excel/nohyperlinks.html>

>
> and
>
> http://www.mcgimpsey.com/excel/removehyperlinks2.html

404 Not Found

This works: <http://www.mcgimpsey.com/macoffice/excel/nohyperlinks2.html>

>
> You can download an add-in that adds a No Hyperlinks toggle command to
> the Tools Menu, and allows you to choose whether to automatically delete
> auto-generated hyperlinks or not. It's still a beta version, but it's
> been stable:
>
> ftp://ftp.mcgimpsey.com/excel/nohyperlinks.xla
>

That works.

--
Paul Berkowitz
MVP MacOffice
Entourage FAQ Page: <http://www.entourage.mvps.org/faq/index.html>
AppleScripts for Entourage: <http://macscripter.net/scriptbuilders/>

Please "Reply To Newsgroup" to reply to this message. Emails will be
ignored.

PLEASE always state which version of Microsoft Office you are using -
**2004**, X or 2001. It's often impossible to answer your questions
otherwise.

[Karl Ryan]

JE McGimpsey wrote:

Try placing an apostrophe (') before you type in the URL or e-mail
address. This should cause Excel to treat anything after the apostrophe
as plain text. Unfortunately, this doesn't work reptrospectively so once
you've typed in the URL and it hyperlinks it you'll have to clear the
cell and start again but with the apostrohpe first.

[Karl Ryan]

> Try placing an apostrophe (') before you type in the URL or e-mail
> address. This should cause Excel to treat anything after the apostrophe
> as plain text. Unfortunately, this doesn't work reptrospectively so once
> you've typed in the URL and it hyperlinks it you'll have to clear the
> cell and start again but with the apostrohpe first.

Or you could try the following macro:

Sub HyperLinks()
Cells.Hyperlinks.Delete
End Sub

[JE McGimpsey]

ThaIn article <BF02C5F8.A893D%berkowit@spoof_silcom.com>,
Paul Berkowitz <berkowit@spoof_silcom.com> wrote:

> On 7/19/05 2:46 PM, in article
> jemcgimpsey-6949...@msnews.microsoft.com, "JE McGimpsey"
> <jemcg...@mvps.org> wrote:
>
> > Take a look here:
> >
> > http://www.mcgimpsey.com/excel/removehyperlinks.html
>
> 404 Not Found
>
> This works: <http://www.mcgimpsey.com/macoffice/excel/nohyperlinks.html>
>
> >
> > and
> >
> > http://www.mcgimpsey.com/excel/removehyperlinks2.html
>
>
> 404 Not Found

Thanks, Paul - my redirects apparently didn't work. These work:

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

and

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

[JE McGimpsey]

In article <jemcgimpsey-6949...@msnews.microsoft.com>,
JE McGimpsey <jemcg...@mvps.org> wrote:

> Take a look here:
>
> http://www.mcgimpsey.com/excel/removehyperlinks.html
>
> and
>
> http://www.mcgimpsey.com/excel/removehyperlinks2.html
>

My redirects apparently didn't work. Try: