![]() |
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