Default Font Setting in Excel Comments

How do I change the default setting for the font in an
Excel Comment from Tahoma 8 pt.?

It might help for me to say that this is in Excel 2003.
Thx in advance for help.

-----Original Message-----
How do I change the default setting for the font in an
Excel Comment from Tahoma 8 pt.?
.

To change the default font size (this will also change the settings for
tooltips in Excel and other programs):

Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK
(Note: selecting a font type here will not affect the default font used
in Excel's comments)

To insert a comment with a specific font, you can use a macro:

http://www.contextures.com/xlcomments03.html#Formatted


tim wrote:
How do I change the default setting for the font in an
Excel Comment from Tahoma 8 pt.?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you for the macro. That may be the route I have to
take. But first I would like to know if there is any way
to change the default setting for the font for "Insert
Comment". If it's set to Tahoma 8 pt. right now
shouldn't there be a way to make the default be 10 pt.?

-----Original Message-----
To change the default font size (this will also change
the settings for
tooltips in Excel and other programs):

Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK
(Note: selecting a font type here will not affect the
default font used
in Excel's comments)

To insert a comment with a specific font, you can use a
macro:


http://www.contextures.com/xlcomments03.html#Formatted


tim wrote:
How do I change the default setting for the font in an
Excel Comment from Tahoma 8 pt.?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

Tim

Did you try Debra's instructions for changing via
PropertiesAppearanceAdvancedItemToolTip?

Change to 10 pt. size here will be default size for Excel Comments.

Gord Dibben Excel MVP

On Tue, 6 Jul 2004 06:06:26 -0700, "tim"
wrote:

Thank you for the macro. That may be the route I have to
take. But first I would like to know if there is any way
to change the default setting for the font for "Insert
Comment". If it's set to Tahoma 8 pt. right now
shouldn't there be a way to make the default be 10 pt.?

-----Original Message-----
To change the default font size (this will also change
the settings for
tooltips in Excel and other programs):

Right-click on the desktop, and choose Properties
On the Appearance tab, click Advanced.
From the Item dropdown, choose Tooltip
Choose a font Size, click OK, click OK
(Note: selecting a font type here will not affect the
default font used
in Excel's comments)

To insert a comment with a specific font, you can use a
macro:


http://www.contextures.com/xlcomments03.html#Formatted


tim wrote:
How do I change the default setting for the font in an
Excel Comment from Tahoma 8 pt.?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.

Ah-ha.....thank you. I was thrown off by the note that this would "not"
change the comment font. I should have tried anyway. thanks again


---
Message posted from http://www.ExcelForum.com/

In the Desktop properties, you can select a Font and Font Size for
Tooltips.
The default Font Size of a new Excel comment is affected by these
settings, but the default comment Font will remain as Tahoma.

tunz wrote:
Ah-ha.....thank you. I was thrown off by the note that this would "not"
change the comment font. I should have tried anyway. thanks again

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html