Hi guys,
I wonder if it is possible to check by means of shapesheet functions if a control point is glued to a point in another shape.
In VBA it would be easy to read out the formula and check if it begins with "LOC(PNT(", but I'd rather like to avoid passing by a macro.
The left function gives back the numeric value in the control's coordinate field. Did not find any "formula" function.
Thanks in advance for your thougths,
Yacine
In V2007, you get similar formula to what you show for the x- and y- cells. For example, in the X cell for a glued control point, this formula occurs: =LOC(PNT(Sheet.5!Connections.X1,Sheet.5!Connections.Y1)). Otherwise, it's just some generic multiple of "width". Sheet.5 was the shape to which the control point was glued.
HTH
Wapperdude