shapes "linked" to cells?

  • Thread starter Thread starter Jarek Kujawa
  • Start date Start date
J

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
 
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
 
I have known that option
thks for reminding though

thus this is the only answer to my question?
 
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?
 
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 -
Click to expand...
 
Back
Top