Comment box defaults

[Peter Andrews]

Can I change the comment box default font and stop it inserting my name in
each box?

Peter

 

[sybmathics]

delete user name from the tools > options > general

 

[sybmathics]

delete user name from the tools > options > general

and replace with a space

 

[Debra Dalgleish]

To change the default font size (Note: this will 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)
You can also set the font to Bold or italic, and select a colour


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

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

 

[Peter Andrews]

To change the default font size (Note: this will 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)
You can also set the font to Bold or italic, and select a colour


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

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

WOW! That's about as far from Excel as is possible. Thanks, at least the
font size is now readable even if still Tahoma!

David