Hyperlinks in Excel

[Guest]

Using Excel 2000 is there a way to remove hyperlinks such that the background
formatting is not also removed? I have a user who needs to remove hyperlinks
from e-mail addresses, in a list, and when she does, all the formatting
(font, borders, shading, etc.) is also removed. - Thanks.

 

[Dave Peterson]

I'm assuming that the user is running a macro that looks essentially like this:

Selection.hyperlinks.delete

If you really wanted, you could find out all the formatting for each of those
cells, remove the hyperlink and then reapply the formatting.

Myself? I'd just reapply the formatting that I wanted.

Another option:

Copy the list, paste special|formats to a safe spot, then remove the links (and
formatting), then copy those saved formats over the original range (and clean up
that helper range).

But when I did this, the text still looked like a link.