 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2004Hyperlinks Turning Them OFF!
I have been unable to find out where and how to have excel turn off the Auto hyperlink feature when web address and email address are typed into excel. Any help would be appreciated in this matter... Hi depending on your Excel version goto 'tools - autocorrection' and choose the middle tab to disable this feature  Signature-- Regards Frank Kabel Frankfurt, Germany > I have been unable to find out where and how to have excel turn off the Auto > hyperlink feature when web address and email address are typed into excel. > Any help would be appreciated in this matter... I am using Excel 2000. I already had tryed looking for the answer there but TOOLS > AutoCorrect only has 1 tab and there is no option listed there. I have also been all over the TOOLS > Options tabs but no luck there either... > Hi > depending on your Excel version goto 'tools - autocorrection' and [quoted text clipped - 10 lines] > excel. > > Any help would be appreciated in this matter... Hi use one of the following alternatives: a) Use the following macro to remove hyperlinks of a chosen selection (after your data entry) Sub RemoveHyperLinks() selection.hyperlinks.delete end sub b) Without macro: - Type the number 1 in a blank cell and copy this cell - Select all your cells with hyperlinks - goto 'Edit - Paste Special' - choose multiply c) Process the Worksheet_change event (see http://www.mcgimpsey.com/excel/nohyperlinks2.html) Signature-- Regards Frank Kabel Frankfurt, Germany > I am using Excel 2000. > I already had tryed looking for the answer there but TOOLS > AutoCorrect [quoted text clipped - 16 lines] > > excel. > > > Any help would be appreciated in this matter... check out http://www.mcgimpsey.com/macoffice/excel/nohyperlinks.html in particular, item 5, and the link to using an event handler to disable automatic hyperlinks. > I am using Excel 2000. > I already had tryed looking for the answer there but TOOLS > AutoCorrect > only has 1 tab and there is no option listed there. I have also been all > over the > TOOLS > Options tabs but no luck there either... Hi Lee Taken from this link http://support.microsoft.com/default.aspx?scid=kb;en-us;233073&Product=x lw2K You can type an apostrophe (') to prevent a hyperlink from being created when you make a cell entry. For example, Excel will automatically create a hyperlink when you type the following text in a cell: http://support.microsoft.com However, Excel will not automatically create a hyperlink when you type the following text: 'http://support.microsoft.com There is the Event Handler method on that link also. |
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
|
©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.