Debra Dalgleish has lots of code for formatting comments at:
http://www.contextures.com/xlcomments03.html
If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
> Is there are way of making permanent changes to the font size used by default
> in a comment? 8pt is too small and editing every comment to change from 8
[quoted text clipped - 3 lines]
>
> Mike

Signature
Dave Peterson