Lock a bonding between 2 shapes

[Miguel]

Hello everyone!

Do you know how can I protect(lock) my bonding between 2 shapes.
Indeed, I glued 2 shapes thanks to connection point. But now, I would like to lock this bonding.
I glued my shapes without VBA code but of course, use a macro is not a problem.

Thank you for your help.

[Yacine]

Write a macro in which you protect the cells PinX and PinY of the glued shape.
Use the macro recorder, add "GUARD(" to the existing formula ")".
Use a variable to get the formula: varFormula = shp.cells("pinX").formulaU
use a generic variable for the shape, like: set shp = activewindow.selection(1)

[Miguel]

Hum I see.. But look, I glued my 2 shapes without vba code and I have this formula in my cells PinX and PinY.

[wapperdude]

...or you could manually guards the formulas without VBA.

Wapperdude

[Yacine]

Yes, the formula generated by the gluing operation needs to be guarded.
Put a "GUARD(" before the formula and a ")" after it.