Error - template LAYOUT-DATA-WRAPPER not found

A configuration error was detected in the CGI script; the LAYOUT-DATA-WRAPPER template could not be found.

Error - template STYLE-SHEET not found

A configuration error was detected in the CGI script; the STYLE-SHEET template could not be found.

Error - template SUB-TOP-BANNER not found

A configuration error was detected in the CGI script; the SUB-TOP-BANNER template could not be found.

Subject:	Re: Excel and hyperlinks
From:	Chris Ryan <[log in to unmask]>
Reply To:	PCSOFT - Personal Computer software discussion list <[log in to unmask]>
Date:	Thu, 9 Jun 2005 05:26:09 -0400
Content-Type:	text/plain
Parts/Attachments:	text/plain (39 lines)

Date:    Wed, 8 Jun 2005 15:34:08 -0400
From:    Bob Lendrim <[log in to unmask]>
Subject: Excel and hyperlinks

I use Excel 2000 to keep a list of email addresses. When an address is
entered in a cell, Excel, by default, makes it a hyperlink. It is possible,
but time consuming, to eliminate the hyperlinks one at a time. Can anyone
tell me how to change Excel so it doesn't create hyperlinks automatically?
Thank you, Bob

Bob, I found a tip and a snippet of code from this website forum and copied
it directly. Credit goes to Gord Dibben.

 "To prevent in the future........

Tools>Autocorrect Options>Autoformat as you type. Uncheck the "replace as
you
type" box.

To get rid of current ones you can edit manually or run a macro on a
selected
range.

Sub removeAllLinksFromSelection()
Selection.Hyperlinks.Delete
End Sub

Gord Dibben Excel MVP"

Hope this helps.
Chris Ryan
[log in to unmask]

        The NOSPIN Group has added a new feature on our website,
           web based bulletinboard for questions and answers:
              Visit our sister website at http://nospin.com

ATOM RSS1 RSS2

LISTSERV.ICORS.ORG