How do I change default font/pitch of text in Excel's comments?

[David Ashford]

I use Excel 2007.
I can format the text in a single comment. However black Tahoma 9 seems to
be the unchangeable default font and pitch.
I want to be able to view bigger and better fonts and pitches without having
to edit each comment one by one.
Thanks for any help you can give.
David.
110309

 

[Gord Dibben]

You can change the default font size, but not the default Font type.

See Debra Dalgleish's site for more info.

http://www.contextures.on.ca/xlcomments02.html#Default

You can however, change the Font and Size and other attributes through code.

http://www.contextures.on.ca/xlcomments03.html


Gord Dibben MS Excel MVP