Hyperlinks (automatic)

H

Hans

When you write a web address like www.whatever.com, it
automaticly turns into a hyperlink. In Excel 2002 and
later, you can get rid of this sometimes rather annoying
feature (Tools-Autocorrect).

But what do you do i Excel 2000?

Regards
 
F

Frank Kabel

Hi
a repost:
-----

depends on your Excel version:
Excel 2002+:
Goto 'Tools - Autocorrection' and choose the middle tab to
disable this
feature

Prior to this version 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)
 
Top