Saving changes to Excel comment defaults

[Guest]

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]

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