ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   delete the hyperlink linked to the organizational chart in excel using vba (https://www.excelbanter.com/excel-programming/334524-delete-hyperlink-linked-organizational-chart-excel-using-vba.html)

asmita[_2_]

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



All times are GMT +1. The time now is 11:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com