Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete hyperlinks from graphical objects in excel sheet
I am trying this coe : Code ------------------- ActiveSheet.Shapes("Organization Chart").Select Set Shp = Selection.ShapeRange For i = 1 To Shp.DiagramNode.Diagram.Nodes.Count Set IShp = Shp.DiagramNode.Diagram.Nodes(i).Shape On Error Resume Next If IShp.Hyperlink.Address < "" Then IShp.Hyperlink.Delete End If On Error GoTo 0 Next i ------------------- -- v_gyk ----------------------------------------------------------------------- v_gyku's Profile: http://www.msusenet.com/member.php?userid=521 View this thread: http://www.msusenet.com/t-187107080 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete 1 row of objects, not all on sheet Excel 2007 | Excel Discussion (Misc queries) | |||
Macros (Graphical Objects) ?? | Excel Discussion (Misc queries) | |||
Macro's and Graphical Objects | Excel Discussion (Misc queries) | |||
Arranging graphical objects on sheet | Excel Programming | |||
Unable to remove Sheet objects in the Microsoft Excel Objects | Excel Programming |