I am trying to remove hyperlink from excel sheet.

I am able to remove hyperlink from auto shapes like callouts, arrow...

its working for images also.

only hyperlinks from organization chart is not goin....



if u see code given below... its not counting the hyperlinks in the organization chart.. i.e. they r not deleted...



Code:
MsgBox (wSheet.Hyperlinks.Count)
                        For i = wSheet.Hyperlinks.Count To 1 Step -1
                            
                            If cancelPwd = True Then
                               Exit For
                            End If

                            If wSheet.Hyperlinks(i).Type <> 0 Then
                              wSheet.Hyperlinks(i).Delete
                              ObjExcel.Save
                            End If
                        Next i