There's code here that will resize the comments:

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


Alt0471 wrote:
It seems that overnight all of the comments in my Excel spreadsheet resized
to a smaller, less convenient size. I am looking for a command that will
make all of them return to their original size without having to resize each
individually.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html