PDA

View Full Version : Turning off Word/Excel Hyperlinking



hillisp
10-11-2004, 03:16 AM
Does anyone know how you stop Word and Excel from turning any webpage or email you type into a hyperlink?
Actually I don't mind if they are hyperlinks or not, I just don't want them to change format (ie to blue and underlines). I wan't them to just stay with the same style as the rest of the text.

Any ideas.

Peter

johnboy
10-11-2004, 08:02 AM
To turn off the automatic creation of hyperlinks in Word 97 or Word 2000:


To turn off hyperlinking.
Choose Tools > AutoCorrect from the menu. The AutoCorrect dialog box will open.

Select the AutoFormat as You Type Tab.

In the Replace as You Type frame, deselect Internet and Network Paths with Hyperlinks.

Click on OK.


hth

Mary H
10-11-2004, 08:05 AM
found this article on google awhile ago when I had the same problem:

http://support.microsoft.com/kb/211955/EN-US/

HTH :o)

Rob99
10-11-2004, 08:08 AM
Tools > AutoCorrect Options... > There are two tabs AutoFormat and AutoFormat as you type, where you uncheck Internet and Network paths with hyperlinks.

Rob99
10-11-2004, 08:09 AM
dammn

Greg S
10-11-2004, 10:44 AM
For a one-off fix, just right-click the link and select Remove Hyperlink

hillisp
10-11-2004, 07:10 PM
OK these solutions worked for Word but it is not one of the options in Excel (Excel 2000 as least). Excel only has the one 'AutoCorrect' tab under tools/AutoCorrect.

Still looking for how to turn them off permanently in Excel - although the right click/hyperlink/remove hyperlink does work is Excel for a once off.

Peter

godfather
10-11-2004, 07:25 PM
Out of luck in Excel 2000
http://www.j-walk.com/ss/excel/usertips/tip031.htm

viper
10-11-2004, 07:27 PM
unfortunately you cant turn them off.

http://www.j-walk.com/ss/excel/usertips/tip031.htm

johnboy
10-11-2004, 08:26 PM
XL2000: How to Prevent the Automatic Creation of Hyperlinks
here (http://support.microsoft.com/default.aspx?scid=kb;en-us;233073)
hth

hillisp
10-11-2004, 08:56 PM
Perfect, thanks Johnboy

The macro option described in Method 2 of http://support.microsoft.com/default.aspx?scid=kb;en-us;233073 works like a charm, and I can include it to autorun on opening the couple of spreadsheets I have with a lot websites in them that were the problem ones.

Another satisfied PressF1 customer