How can i remove the several hyperlink option after entering the .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello Sir

I have been working in the office 2000 on excel worksheet for an data entry
purpose. The problem is i have copied many ids from internet and pasted in
the work sheet it was pasted as hyperlink. I want to remove all the
hyperlinks at once without removing / deleting the content. I just want to
remove the hyperlink in the several ids. What is the step to remove it.
Reply me as soon as possible.
Thaking You...
 
use the following macro

Sub RemoveAllHyperLinksPerSheet()
Dim i As Integer
For i = ActiveSheet.Hyperlinks.Count To 1 Step -1
ActiveSheet.Hyperlinks(i).Delete
Next i
End Sub
 
Back
Top