 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / December 2008Automatic Creation of Hyperlink when entering an email address
Version: 2004 Operating System: Mac OS X 10.4 (Tiger) Processor: Intel Hi, I looking for a way to turn off the automatic creation of a hyperlink when I enter an email address into a cell. When I type me@myspot.net Execl is automatically turning this into a hyperlink that displays as blue underlined text with a value of mailto:me@myspot.net. It creates a lot of extra work to have to go back and remove the hyperlink attribute each time I enter an email address. Thanks, CVBruce > Version: 2004 > Operating System: Mac OS X 10.4 (Tiger) [quoted text clipped - 9 lines] > mailto:me@myspot.net. It creates a lot of extra work to have to go back and > remove the hyperlink attribute each time I enter an email address. See http://mcgimpsey.com/macoffice/excel/nohyperlinks.html and, for an event handler method http://mcgimpsey.com/macoffice/excel/nohyperlinks2.html They're listed for XLv.X and 01, but work in 04 as well. XL08 *finally* has a preference setting... Hi Great tip, but only if I knew how to actually implement the solution.:-) This particular element has been driving me crazy not only in Excel, but in Word as well. Running OfFice 2005, on Mac OSX 10.5.5 Thanks for your help. Best regards Alan Whitford > Hi > > Great tip, but only if I knew how to actually implement the solution.:-) Not sure what tip you're referring to - you replied to an original post rather than a reply containing a tip. > This particular element has been driving me crazy not only in Excel, but in > Word as well. > > Running OfFice 2005, on Mac OSX 10.5.5 Since there is no office 2005 for any platform it's hard to know how to respond... You can turn the conversions off in Word 2004/2008 (Tools/Autocorrect/Autoformat as you type - uncheck the Internet paths checkbox). I also have the same problem and it is a big pain. I am using EXCEL 2004 on a Mac when i enter an email address into a cell it turns blue and creates a hyperlink. The I have to go through numerous machinations to get it not to be a hyperlink, remove the underline, change the color, and match the font and size to the rest of the column. I read some of your hints and links, GADS can it be more complicated! Again I am using EXCEL not WORD. Any SIMPLE help would be greatly appreciated by me and i am sure CV Bruce. Something easy like a entry into the Format/cell area. thanks bob > I also have the same problem and it is a big pain. > I am using EXCEL 2004 on a Mac [quoted text clipped - 7 lines] > Any SIMPLE help would be greatly appreciated by me and i am sure CV Bruce. > Something easy like a entry into the Format/cell area. Since you're replying to a post that already has been answered, I'm assuming the "hints and links" include those I posted. FIrst, I feel your pain - thankfully the option to turn that autocorrection off was FINALLY implemented in XL08, only a couple of versions after it was put into WinXL. Of course, the SIMPLEST way (the first suggestion in the first link - and MUCH simpler than what you're currently doing) is to prefix the entry with an apostrophe. 1 extra key-press, but you need to remember to enter the prefix in advance. The next most SIMPLE method (and the second suggestion in that link - also much simpler than what you're going through) is to type CMD-z after the autocorrection is made. Two key-presses. Anything else is indeed more complicated - but the options are pretty much limited to those other suggestions I made before. |
Reply to this Message |
 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
|
©2009 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.