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
 

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
How do I remove numerous Hyperlinks all at once within a worksheet 3
Excel Hyperlink 0
eliminating hyperlinks from a complete column in Excel 4
Clicking on cell with email address opens Outlook Express 2
make Hyperlink jump on the top row 2

Back
Top