Deleting "mail to:" email address links

  • Thread starter Thread starter Frank Quaglietta
  • Start date Start date
F

Frank Quaglietta

I have a relativly straight forward spreadsheet where I
am maintaining a large address list. It contains a
homeowner's lot number, name, address, telephone #, and e-
mail address. When attempting to select random cells for
data entry/modification, I receive and automated
message " mailto: (a random e-mail address) - click once
to follow. Click and hold to select this cell."
I have no idea where/how this message/feature/function is
being attached to these cells but would like to eliminate
it. Since seeing these messages, the size of the
worksheet has been increasing in size as evidenced by the
amount of time required to "save" the sheet.
 
Dave,

Thanks a million. I owe you one!!

Frank
-----Original Message-----
Select your range to clean up (ctrl-A will get the whole sheet).

Hit alt-F11 to get to the VBE
hit ctrl-G to see the immediate window
type in
selection.hyperlinks.delete
and hit enter.

These were created when excel saw you used @ in a cell. In xl2002, there's an
autocorrect option to disable this "helpful" feature.





--

Dave Peterson
(e-mail address removed)
.
Click to expand...
 
Back
Top