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
 

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.

Ask a Question

Similar Threads

How can i remove the several hyperlink option after entering the . 2
Activating hyperlinks 3
Copy Hyperlink command 1
removing more than one hyperlink 2
Will not auto open .jpg 1
How to remove so many hyperlink in a single click? 4
How can I remove ALL hyperlinks in a document in Excel 2003? 2
How do I remove numerous Hyperlinks all at once within a worksheet 3

Back
Top