Maybe you could use some code from Debra Dalgleish to reset the comments.
http://contextures.com/xlcomments03.html#Reset
and
http://contextures.com/xlcomments03.html#Resize
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
RWS wrote:
My comment boxes experience the following conditions:
1. they collapse and can't be read unless I re-size the box
2. they grow into much bigger than necesary for the text they contain
3. they appear many rows away from the cell with the red comment indicator
When I edit a comment one or more of the above conditons apply.
I make the necessary changes, but they don't stay. When I re-open the file,
the above conditions are back.
--
Dave Peterson