Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comment Default Font Size
Hello,
Does anyone know how I can change the default font size of the comment feature in Excel? It currently deaults to size 8, which is hard to read so I always manually change it to 10. Any suggestions would be appreciated. John |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Comment Default Font Size
You can change the font size of new comments by changing the settings in
your Control Panel. (Instructions for Windows XP) 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 a font Size, click OK, click OK Note -- this will also affect your Tooltips formatting Or, you can use a macro to insert a comment with a specific font and format: '====================================== Sub CommentAddOrEditTNR() 'adds TimesNewRoman comment or positions 'cursor at end of existing comment text Dim cmt As Comment Set cmt = ActiveCell.Comment If cmt Is Nothing Then ActiveCell.AddComment text:="" Set cmt = ActiveCell.Comment With cmt.Shape.TextFrame.Characters.Font .Name = "Times New Roman" .Size = 11 .Bold = False .ColorIndex = 0 End With End If SendKeys "%ie~" End Sub '=========================== John M wrote: Does anyone know how I can change the default font size of the comment feature in Excel? It currently deaults to size 8, which is hard to read so I always manually change it to 10. Any suggestions would be appreciated. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the default (Insert) comment font size in Excel2007 | Excel Discussion (Misc queries) | |||
Excel 2003 - setting the Comment font size default | Excel Worksheet Functions | |||
default font size of comment | Excel Discussion (Misc queries) | |||
Need feature to change font size default in COMMENT boxes. | Excel Discussion (Misc queries) | |||
Default cell comment fill color and font size | Excel Discussion (Misc queries) |