shapes "linked" to cells?

[Jarek Kujawa]

could anybody possibly explain the following to me:

presume I insert a textbox to a worksheet the top/left corner of which
is "over" cell C7 for example
when I change the height of row 7 or width of column C the textbox
size "adjusts" to those changes

as if it was somehow "linked" to cell C7 - is it true? if so can
anyone explain this to me or send a link where I could read about it
(cause I never found any info on this)

I know that Shapes objects uses different coordinate system than
worksheet cells and Windows system windows

thks in advance

 

[Peter T]

Right click the shape (with your textbox rt-click on a border),
Properties...

Notice the three move/size options. From what you described your textbox is
set to "Move and size with cells"

Regards,
Peter T

 

[Jarek Kujawa]

I have known that option
thks for reminding though

thus this is the only answer to my question?

 

[Peter T]

The basic coordinate system for shapes is position (points from top left
corner) and size (width & height) in points. Shapes are indirectly linked to
cells inasmuch as they have TopLeftCell and BottomRightCell properties (as
range objects).

If a gridline on left or top border of the 'TopLeftCell' changes the shape's
position will change. If an intersecting gridline changes the shape will
resize, also bottom/right gridline if the shape's bottom or right border was
on the gridline originally, subject move & size option.

Not sure if that covers your question.

Regards,
Peter T

I have known that option
thks for reminding though

thus this is the only answer to my question?

 

[Jarek Kujawa]

it really does
thks a million Peter

The basic coordinate system for shapes is position (points from top left
corner) and size (width & height) in points. Shapes are indirectly linkedto
cells inasmuch as they have TopLeftCell and BottomRightCell properties (as
range objects).

If a gridline on left or top border of the 'TopLeftCell' changes the shape's
position will change. If an intersecting gridline changes the shape will
resize, also bottom/right gridline if the shape's bottom or right border was
on the gridline originally, subject move & size option.

Not sure if that covers your question.

Regards,
Peter T


I have known that option
thks for reminding though

thus this is the only answer to my question?







- Pokaż cytowany tekst -