I have a worksheet that has a number of comments scattered all over.

I'm using the default 'Edit Comment' Excel function to build them all.

I set the size manually cropping all the extraneous space so the area of the
comment is only aruond the text I want.

Thinking that I'm done, I continue doing development, modifying macros for
other sections. However, when I come back to some of the cells that I've
inserted comments for, I notice that the comment field grows, esp if after
i've 'corrected' the size of the comment field, I write a value to the cell.


Is there any way I can fix the size of the comment field so that it will
keep from doing this ? Or do I have to write a custom macro / form to handle
this ?

Thanks,
Chad