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.