View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default shapes "linked" to cells?

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" wrote in message
...
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