Default cell comment fill color and font size

[Shadowman13]

Is there a way to change the default settings for Excel 2003 comments?
I would like to change the default fill color as well as change the default
font size.

If these settings can be changed, please provide details!

Thanks.

 

[David McRitchie]

see Cell Comments
http://www.mvps.org/dmcritchie/excel/ccomment.htm#font
for suggestions with dealing with changes before you start making changes
http://www.mvps.org/dmcritchie/excel/colors.htm#BackupDisplay

You can set the default interior color, the font color, and the fontsize in the
Control Panel (Display, Appearance, Tool Tip).

 

[Gord Dibben]

Without using VBA code the only method is to right-click on Desktop and
Properties>Appearance>Advanced>Item>ToolTip

Make changes to font size and background color here.

This is a global setting will affect all ToolTips.

For coding see Debra Dalgleish's site.

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


Gord Dibben Excel MVP