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

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

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

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

On Wed, 11 Mar 2009 15:49:02 -0700, David Ashford
wrote:

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