Automatting hyperlink removal

  • Thread starter Thread starter Judy
  • Start date Start date
J

Judy

Is there a way to automate the removal of hyperlinks in
excel to specific columns instead of the whole sheet. I
have a user that would like to create macro that would
remove hyperlinks in some columns that she could specify.

Thanks
 
Judy

You could do it by copying an unused cell, select your column, and go to
Paste/Special/Add

Andy.
 
One from David McRitchie, select the range and run

Sub RemoveHyperlinks()
'David McRitchie, misc, 2003-04-08
Dim cell As Range
For Each cell In Intersect(Selection, ActiveSheet.UsedRange)
On Error Resume Next
cell.Hyperlinks.Delete
Next cell
End Sub
 
Here's the one I use which doesn't need to loop through the cells.

Sub RemoveHyperlinks()
On Error Resume Next
Selection.Hyperlinks.Delete
End Sub
 
Back
Top