How can i remove the several hyperlink option after entering the .
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... |
How can i remove the several hyperlink option after entering the .
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 " wrote: 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... |
All times are GMT +1. The time now is 05:35 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com