Automatting hyperlink removal

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
 
A

Andy B

Judy

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

Andy.
 
K

Ken Wright

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
 
R

Robert Rosenberg

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
 
Top