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

 

[Paul Berkowitz]

Take a look here:

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

404 Not Found

and

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

404 Not Found

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]

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

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>,

404 Not Found




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]

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:

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

and

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