Change default font for comment box 
Author Message
 Change default font for comment box

The default font for a comment box is Tahoma 8. HOW/WHERE
can I change this to (for example) Ariel 10. I have looked
in Windows configuration, searched the registry, but found
nothing.


Thu, 07 Jul 2005 14:01:15 GMT  
 Change default font for comment box
You can change the font size (but not the font, AFAIK) of new comments
by changing the settings in your Control Panel (instructions for Windows
XP). This will also affect the Tooltip appearance:

1. Right-click on the desktop, and choose Properties
2. On the Appearance tab, click Advanced.
3. From the Item dropdown, choose Tooltip
4. Choose Font Size, click OK, click OK

Or, you could format existing comments by using a macro:

Sub FormatComments()
Dim cmt As Comment
     For Each cmt In ActiveSheet.Comments
       With cmt.Shape.TextFrame.Characters.Font
         .Name = "Arial"
         .Size = 10
         .Bold = False
         .ColorIndex = 0
       End With
     Next
End Sub

Quote:

> The default font for a comment box is Tahoma 8. HOW/WHERE
> can I change this to (for example) Ariel 10. I have looked
> in Windows configuration, searched the registry, but found
> nothing.

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


Thu, 07 Jul 2005 16:44:44 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Change Default Font Size in Comments

2. Change default font for comments

3. HELP: changing default font in comments

4. ?Change default font options for comments?

5. Changing default font - comments

6. Changing the Default Font for Comments

7. Changing Comment Font Defaults

8. change font attributes excel comment box

9. change font attributes excel comment box

10. change font attributes excel comment box


 
Powered by phpBB® Forum Software © phpBB Group