Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Default cell comment fill color and font size
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. |
#2
|
|||
|
|||
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...#BackupDisplay You can set the default interior color, the font color, and the fontsize in the Control Panel (Display, Appearance, Tool Tip). --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Shadowman13" wrote in message ... 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. |
#3
|
|||
|
|||
Without using VBA code the only method is to right-click on Desktop and
PropertiesAppearanceAdvancedItemToolTip 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 On Wed, 28 Sep 2005 09:49:25 -0700, "Shadowman13" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|