How to remove multiple hyperlinks at once

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
You will need to create a macro to delete the hyperlink addresses in your Excel sheet.

Open your Excel spreadsheet that you wish to remove the hyperlinks from. Press <ALT>-F11 to go to the Visual Basic editor. Create a new module. You can do this by selecting Module under the Insert menu.

Paste the following code into your new module:

Sub RemoveHyperlinks()

'Remove all hyperlinks from the active sheet
ActiveSheet.Hyperlinks.Delete

End Sub

Close the Visual Basic editor window by selecting "Close and Return to Microsoft Excel" under the File menu.

Now, go to the sheet that contains the hyperlinks that you wish to delete.
 
Back
Top