Nausherwan> Hello! My name is Nausherwan, how may I help you today?
seo> Im seo
seo> Yaa
seo> actually i want to know that
seo> How to remove multi hyperlink
seo> in excel
seo> U can help me?
seo> ??
Nausherwan> ok. please wait
seo> k
Nausherwan> you may try Worksheet.Hyperlinks.Clear()
Nausherwan> this will remove all the hyperlinks
Nausherwan> but you have to update the formatting of the text manually
seo> yes
seo> how
seo> I have no idea
seo> how can i done this
Nausherwan> well, the better way is to remove the hyperlinks one by one by using Worksheet.Hyperlinks.RemoveAt API in a loop
seo> yes
seo> i knw
seo> one by one
Nausherwan> this way the formatting will be removed automatically
seo> but i want multiple
seo> in my excel sheet
seo> 1000 url hyperlink
seo> and i want to remove all hyperlink
seo> at a time
seo> if I will use one by one
seo> so much time
seo> for one by one
seo> so i want to know multi ple
seo> I think ur dont know
seo> well thanks for ur time
Nausherwan> well, there is only one way
Nausherwan> to use Hyperlinks.Clear() method
Nausherwan> so you have to remove the formatting of the cells containing the hyperlinks one by one<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
This message was posted using Email2Forum by nausherwan.aslam.