Hyperlinks Turning Them OFF!

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

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
 
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
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)
 
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.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****
 
Back
Top