How to remove multiple hyperlinks at once

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Janne Siukkola - 14 Sep 2007 08:22 GMT

Greetings

I have copied quite large amount of data from my companys web based
information system and pasted it to Excel (XP/2002). In that data were names
that work as hyperlinks to e-mails.

How can I remove multiple (like 100) hyperlinks at once?

I know that if I click one cell containing hyperlink with right mouse button
I got an option of "Remove Hyperlink", but how to do that to two (or one
hundred billion) hyperlinks?

Thank you for any help.

Signature

- Janne Siukkola -

Reply to this Message

Pete_UK - 14 Sep 2007 09:19 GMT

Once you have pasted the items into Excel (i.e. with the data still
highlighted), press Alt-F11 to take you into the VBE, then CTRL-G to
take you into the Immediate Window, and then type:

selection.hyperlinks.delete (Enter)

This will get rid of all your hyperlinks in one operation.

Hope this helps.

Pete

On Sep 14, 8:22 am, Janne Siukkola
<JanneSiukk...@discussions.microsoft.com> wrote:

> Greetings
>
[quoted text clipped - 12 lines]
> --
> - Janne Siukkola -

Reply to this Message