Hi Experts,
I have an Excel spreadsheet that has hyperlinks randomly scattered in different cells within the spreadsheet, is there a way of having a macro that can remove all hyperlinks in the spreadsheet. Thanks
Sam
For Each Hyperlink In ActiveSheet.Hyperlinks
Hyperlink.Delete
Count = Count + 1
Next Hyperlink
MsgBox Count & " hyperlinks deleted."
End Sub
Kevin
0
samirstAuthor Commented:
Guys, both solutions worked perfectly and have the exact timestamp when posted. So the best option is to split the points equally. Many thanks for your help.
Sam
Sub test()
For Each hp In ActiveSheet.Hyperlinks
hp.Delete
Next hp
End Sub
Claus Henriksen