I'm not sure you can control this, but you can reset them with a macro:
http://www.contextures.com/xlcomments03.html#Resize
from Debra Dalgleish's site.
JoeP wrote:
For some reason, the size of the comment box changes over time - not sure
why. Some boxes seem to get bigger and some boxes shrink so that you cannot
even read the text in them.
Is there a way to 'lock' the comment box size so that it does not change?
Thanks.
Joe
--
Dave Peterson