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
Mike Sullivan wrote:
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
to 10 is painful, as there dozens of them!
TIA
Mike
--
Dave Peterson