What is the deal with Comment Object Positioning?
 

I have tried exhaustively to lock down comments in relation to their
respective cells.
Regarding the 3 options:
Move and size
Move but don't size
These seem to do something but nothing rational. For example,
Move-but-don't-size will not lock to the associated cell, but I can't see why
not. When I insert a row above, the comment (upon editing) is not in the same
relation to the cell as before.

Any ideas?

Thanks,
Mark

How about just putting them back where they belong?

http://www.contextures.com/xlcomments03.html#Reset
From Debra Dalgleish's site.

Mark wrote:

I have tried exhaustively to lock down comments in relation to their
respective cells.
Regarding the 3 options:
Move and size
Move but don't size
These seem to do something but nothing rational. For example,
Move-but-don't-size will not lock to the associated cell, but I can't see why
not. When I insert a row above, the comment (upon editing) is not in the same
relation to the cell as before.

Any ideas?

Thanks,
Mark

--

Dave Peterson

I have used some of her code and it is helpful.

But what about the function itself? What does "Move but don't size with
cells" really mean?

"Dave Peterson" wrote:

How about just putting them back where they belong?

http://www.contextures.com/xlcomments03.html#Reset
From Debra Dalgleish's site.

Mark wrote:

I have tried exhaustively to lock down comments in relation to their
respective cells.
Regarding the 3 options:
Move and size
Move but don't size
These seem to do something but nothing rational. For example,
Move-but-don't-size will not lock to the associated cell, but I can't see why
not. When I insert a row above, the comment (upon editing) is not in the same
relation to the cell as before.

Any ideas?

Thanks,
Mark

--

Dave Peterson

To me, comments have always had a mind of their own.

I've never depended or used those options. But I could play with those settings
and change the height of the row and the comment's size would change, too (and
size with cell was chosen).



Mark wrote:

I have used some of her code and it is helpful.

But what about the function itself? What does "Move but don't size with
cells" really mean?

"Dave Peterson" wrote:

How about just putting them back where they belong?

http://www.contextures.com/xlcomments03.html#Reset
From Debra Dalgleish's site.

Mark wrote:

I have tried exhaustively to lock down comments in relation to their
respective cells.
Regarding the 3 options:
Move and size
Move but don't size
These seem to do something but nothing rational. For example,
Move-but-don't-size will not lock to the associated cell, but I can't see why
not. When I insert a row above, the comment (upon editing) is not in the same
relation to the cell as before.

Any ideas?

Thanks,
Mark

--

Dave Peterson


--

Dave Peterson