View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
asmita[_2_] asmita[_2_] is offline
external usenet poster
 
Posts: 1
Default delete the hyperlink linked to the organizational chart in excel using vba


hi
i am trying to remove hyperlinks that are linked to objects in th
excel workbook using vb.
the code that i am using is as follows:

If wSheet.Hyperlinks(i).Type < 0 Then
wSheet.Hyperlinks(i).Delete
ObjExcel.Save
hashyperlinks = True
End If

this code does not remove hyperlinks from the organizational charts
flow charts, cycle diagrams, etc. it just removes hyperlinks from th
images
can some1 pls help.

thanks in advanc

--
asmit
-----------------------------------------------------------------------
asmita's Profile: http://www.excelforum.com/member.php...fo&userid=2517
View this thread: http://www.excelforum.com/showthread.php?threadid=38714