$(#^% Hyperlinks in Excel vX

[Rothrock]

I'm working with Excel vX on a Mac. I'm trying to put in a bunch of
e-mails and web addresses. But they are always turned into hyperlinks
- which I don't want. If I have to go back and edit it tries to open
the link or send the e-mail and this slows me down way to much.

I searched this group and found:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Target.HyperLinks.Delete
End Sub

Which doesn't quite work. It allows the hyperlink to be formed, but it
removes the formating if I go back.

Is there anyway to turn this off completely or another code that will
stop the dreaded hyperlink? Thank you for any help.

 

[JE McGimpsey]

I'm working with Excel vX on a Mac. I'm trying to put in a bunch of
e-mails and web addresses. But they are always turned into hyperlinks
- which I don't want. If I have to go back and edit it tries to open
the link or send the e-mail and this slows me down way to much.

I searched this group and found:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Target.HyperLinks.Delete
End Sub

Which doesn't quite work. It allows the hyperlink to be formed, but it
removes the formating if I go back.

Is there anyway to turn this off completely or another code that will
stop the dreaded hyperlink? Thank you for any help.

Take a look at

http://www.mcgimpsey.com/excel/nohyperlinks2.html

 

[Rothrock]

At this point in my day that seems a bit much. But I'm sure it will
make sense when I sit down in front of Excel tomorrow at work. I can
hardly wait!

Thank you, thank you.

 

[Rothrock]

McGimpsey - tried it and it worked great. I don't really quite
understand about modules and things in the startup folder and all, but
it seems to only work for new documents. I'm guessing that is how it
should be, but is there a way to make it load that
class/module/macro/what-ever-it-is into an existing workbook?

Thank you!

 

[Rothrock]

Oh I just realized that I had closed my NoHyperlinks.xls (the name I
gave it) workbook, that is why. So I guess now my question is:

Is there a way to hide that and keep it open always and forever? Or is
there someway I can put the code someplace that I don't have to see it?

 

[JE McGimpsey]

Oh I just realized that I had closed my NoHyperlinks.xls (the name I
gave it) workbook, that is why. So I guess now my question is:

Is there a way to hide that and keep it open always and forever? Or is
there someway I can put the code someplace that I don't have to see it?

one way is to put the code in an add-in.

Create a new workbook with one worksheet. Paste the code in the
appropriate modules for that workbook. Return to XL.

Save the workbook as an add-in (File/Save As..., choose "Excel Add-in"
from the Format drop-down).

If you want to manually determine whether the add-in is active or not,
save the file to a location of your choice. Install the add-in using
Tools/Add-ins/Select and browse to the add-in).

If you want the add-in to be active all the time, save the file to the

HD:Applications:Microsoft Office 2004:Office:Startup:Excel

folder. Close and reopen XL - hyperlinks will be automatically removed.

 

[Rothrock]

Thank you so much. You have answered one of my dreams! Now if you know
how to find me a date for Friday night...