Positioning unhidden comments for printing

[Dusty85]

Is there a way to make unhidden comments move with the cells they are
attached to? My spreadsheet contains comments that I want to print as
displayed (vs at the end of the sheet). It works fine until I change a
column width, move data, add/delete a column, etc. The comments don't
move with the cells they are attached to and I can see no consistency
in the way they do move. If I shift a cell 10 spaces, the comment
might move halfway across the page in either direction. I spend a lot
of time manually moving them back into position, so I'll be very
grateful if anyone can help (or at least let me know there's no way to
prevent the problem so I can stop looking for a solution!)

Thanks!

 

[Dave Peterson]

Those comments have a mind of their own, don't they?

Debra Dalgleish has some code to reposition them. Maybe you could take some of
that and make it do what you want.

http://www.contextures.com/xlcomments03.html#Reset

 

[Dusty85]

Thanks Dave, I'll give that a try.

Dusty