Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Setup / July 2003

Tip: Looking for answers? Try searching our database.

Disable Automatic Hyperlink

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
MMD - 24 Jul 2003 19:45 GMT
Does anyone know how to prevent Excel from converting
items in a cell to a hyperlink?  It automatically formats
things that are like "05/31@06/30" to a hyperlink.

Thanks for your help
David McRitchie - 24 Jul 2003 21:10 GMT
Hi ....,
You may find it a lot simpler to just let them be created
and then delete the hyperlinks all at one time from a selection
with a macro.

You can immediately undo the hyperlink with UNDO (Ctrl+z).  If you
have not entered a hyperlink already you can precede the text with a single quote.

Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

subtopic:  Removing object hyperlinks from a Cell or cell range (#DelHyperlinks)
 http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperlinks

   Sub DelHyperLinks()
      Selection.Hyperlinks.Delete
   End Sub

For those with Excel XL (Excel 2002) you can suppress hyperlink generation
under the Auto Correct from the Tools menu.
   Tools (menu), Autocorrect Options, Autoformat as you type (Tab).

If not familiar with installing / using macros see
  http://www.mvps.org/dmcritchie/excel/getstarted.htm

All that being said,  you could have done a search on Google Groups
   http://groups.google.com/advanced_group_search?q=group:*Excel*&num=100
search for all words:   disable automatic hyperlink*

and I am positive  you would have found threads previous to this with answers.
but my  buildtoc.htm#delhyperlinks    will have the information in one place
along with additional information on this and related issues..
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

> Does anyone know how to prevent Excel from converting
> items in a cell to a hyperlink?  It automatically formats
> things that are like "05/31@06/30" to a hyperlink.
>
> Thanks for your help
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.