Hyperlinks

P

poola

I have a client contact list at work in the form of a
Excel 2000 spreadsheet.
When the pointer hovers over some names, the pointer turns
into a hand, as if it were an email adress.
There are no email adresses in the spread sheet, but if
the name is clicked on, the default email program is
launched.
I tried right clicking on the name, but there is no
Properties option.

I don't know how to get rid of this linking, and it is
really driving me mad.

Any suggestions are greatly appreciated.

poola
 
D

David McRitchie

You once had an email address and typed over it.
You can eliminate with or without a macro, for me the macro
is setup and easier to use.

without a macro:
select an empty (never used cell) and copy it (Ctrl+C)
then select the cells or column that you want to change, then
Edit, Paste Special, Add

For a macro solution the VBA code found on my buildtoc.htm page is:

Sub DelHyperLinks()
Selection.Hyperlinks.Delete
End Sub
 
Top