MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Hyperlinks


Posted by Jennifer Ann on October 29, 2001 12:31 PM

When I copy information from our Intranet and paste it in to Excel, a column of that information contains hyperlinks that only work over our Intranet. I know how to remove the hyperlinks one at a time, but the 'Hyperlink' sub menu available when I right-click over one of those hyperlinks is not there when I try to select the whole column full of hyperlinks. Is there a way to delete all of them at once?

My thanks in advance for your replies.


Posted by Juan Pablo on October 29, 2001 12:38 PM

Try this macro. To use it select the range you're trying to delete and then run it

Private Sub EraseHypherLinks()
On Error Resume Next
For Each cll In Selection
cll.Hyperlinks(1).Delete
Next cll
End Sub

Juan Pablo

Posted by Jennifer Ann on October 30, 2001 4:30 AM

Thank you Juan!!

It's a beautiful thing. Much thanks to you!