How to turn huperLink off in Excel for OS X

[J.E. McGimpsey]

AFAIK, there's no way to turn off automatic hyperlink generation in XLv.X.

You can, after making an entry that is turned into a hyperlink, type CMD-Z
(Undo) to remove the hyperlink.

Or, you could put this macro in the ThisWorkbook module of your workbook
(CTRL-click on the title bar and paste the code below into the Visual Basic
Editor window "ThisWorkbook" that opens. You can delete the empty
Workbook_Open macro if you wish. Then click on the XL icon in the formula
toolbar to return to XL). From then on, hyperlinks will automatically be
removed.

Private Sub Workbook_SheetChange(ByVal Sh As Object, _
ByVal Target As Excel.Range)
With Target.Hyperlinks
If .Count Then .Delete
End With
End Sub

If you want this feature on all new workbooks, put the macro in an empty
workbook and save it *as a template* in the

Microsoft Office X:Office:Startup:Excel:

folder in your Applications folder with the name "Workbook" (no extension).
This template will then be used for all subsequent new workbooks (unless you
choose a different template).

On 11/19/2002 16:25, in article
a24001c29022$ea90ef50$8df82ecf@TK2MSFTNGXA02, "Claire Slemmer"
<cla...@crywolf.com> wrote:

> Anyone know how to turn off hyperlink (hypertext?). Problem = I
> DO NOT want cells containing web sites or e-mail addresse
> records to launch the browser or mail program when I need to
> edit the cell.
>
> I'd like hyperlink to be turned off as the default for any new
> spreadsheet as well.
>
> Thanks so very much in advance for your help.
>
> Claire

[George Clark]

You can also Control-click on the hyperlink and select 'Hyperlink...' from
the menu, then click on the 'Remove hyperlink' button, to just remove the
hyperlink from one such.

George

On 11/19/02 23:16, J.E. McGimpsey did expound most eloquently:

--
Mac Word FAQ: <http://www.mvps.org/word/FAQs/WordMac/index.html>
Entourage Help Page: <http://www.entourage.mvps.org/>
Or try Google: <http://www.google.com>

Please do not reply to this message. Although the email address is perfectly
valid, any replies to this account never get to the Inbox on my computer.