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

P

pravin.87

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...
 
B

bj

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

Mass-remove hyperlinks from Publisher Document (VBA macro) 0
How can i remove the several hyperlink option after entering the . 2
Weird behaviour when entering hyperlinks 0
Embed the same Excel multiple times 0
Macro attached to Autoshape Hyperlink not invoking 0
Cannot remove empty rows 8
Odd Remove Hyperlink Behavior 0
Compare identifier columns from 2 sheets - remove rows that are dups 2

Top