Hyperlinks

  • Thread starter Thread starter poola
  • Start date Start date
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
 
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
 
Back
Top