I found the answer by stumbling around my worksheet, if you open the drawing
tool and edit the comment box by putting a shadow on the box WALA the box
maintains it size when your close and reopen the worksheet

"Eddie O" wrote:

I can confirm that that happens to me too (and I use excel 2000), but know of
no fix...

"Brian J. Tully" wrote:

how can I "fix" comment box size? It changes ever time I close the worksheet!