How to make comments move with cells when cutting pasting, or inserting rows

[anonymous]

I have to insert / delete rows or move cells often. When
I do this, my "comments" boxes don't move with the cells
(they end up all over the place), and they often grow
tremendously.

Is there some way to make the comment boxes autosize and
follow the cells???

Thanks!

 

[Dave Peterson]

Debra Dalgleish has some code that does lots of things to comments:
http://www.contextures.com/xlcomments03.html

Including resizing them:
http://www.contextures.com/xlcomments03.html#Resize

(and repositioning them to their original spot (just scroll up on that last
link).)