Removing hyperlink from multiple cells in Excel

  • Thread starter Thread starter L
  • Start date Start date
L

L

How can I remove hyperlink from a column all at once? I
have only found a way to do it cell by cell.
 
Slight Tweak on previous post of Dave's for removing screen tips. Select the column and run the
routine.

Sub RemoveHyperlinks()
'David McRitchie, misc, 2003-04-08, misc
Dim Cell As Range
For Each Cell In Intersect(Selection, ActiveSheet.UsedRange)
On Error Resume Next
Cell.Hyperlinks.Delete
Next Cell
End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Activating hyperlinks 3
Hyperlinks 1
Excel Macro to hyperlink an archived worksheet to an index page 0
Excel Hyperlink 0
How do I remove numerous Hyperlinks all at once within a worksheet 3
eliminating hyperlinks from a complete column in Excel 4
Clicking on cell with email address opens Outlook Express 2
hidden Hyperlink 1

Back
Top