M
marmaduke
I want to be able to use connectors to cells so that if I move or resize the
cell, it stays connected
cell, it stays connected
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Sean Timmons
After you enter the drawing object on yoru worksheet, right-click on it.
Select Format AutoShape. Click the Properties tab. Ensure Move and Size with
cells is checked.
Select Format AutoShape. Click the Properties tab. Ensure Move and Size with
cells is checked.
M
marmaduke
Thanks for the reply and I am part way there with your answer. I draw a
rectangle over one corner of my cell, put data in my cell, connect that
rectangle with another drawn object and then move the cell with the data.
The rectangle follows and stays overtop the moved cell, but the arrow
connector does not stay connected to the rectangle that moved with my cell.
I hope that makes sense
rectangle over one corner of my cell, put data in my cell, connect that
rectangle with another drawn object and then move the cell with the data.
The rectangle follows and stays overtop the moved cell, but the arrow
connector does not stay connected to the rectangle that moved with my cell.
I hope that makes sense
S
Sean Timmons
Sorry for the delay in replying.
And you verified the arrow object has the same properties selected as the
square? Does the arrow object move at all, or is it a matter of it not moving
to the spot it once was? Are you resizing the cell? This would cause the
arrow to point to a different part of the rectangle...
And you verified the arrow object has the same properties selected as the
square? Does the arrow object move at all, or is it a matter of it not moving
to the spot it once was? Are you resizing the cell? This would cause the
arrow to point to a different part of the rectangle...