How do I change default font for all new comments in Office 2003?
I just installed Office 2003 and transfered excel files from the older
version. The comments that I had created before I moved to 2003 look fine in the default font (Tahoma); however, when I try to insert a new comment, the same font (same size, same formatting) the text looks virtually unreadable. I changed font in some comments and they look much better, but it is extremely inefficient to try to change font in every new comment I insert, so I thought maybe there is a way to do it on a default basis. Or maybe I somehow could change something to make Tahoma appear readable. Please, assist. |
We have no control over the default font Excel uses with new comments. I
saw no difference in the way the Tahoma font in comments looked in Excel 2003 versus earlier versions. Pretty weird. You can change comment fonts en masse with a macro though... Sub ChgAllCommentFonts() Dim Cell As Range For Each Cell In Cells.SpecialCells(xlCellTypeComments) With Cell.Comment.Shape.TextFrame.Characters.Font .Name = "Terminal" .Size = 9 End With Next End Sub -- Jim "Elena" wrote in message ... |I just installed Office 2003 and transfered excel files from the older | version. The comments that I had created before I moved to 2003 look fine in | the default font (Tahoma); however, when I try to insert a new comment, the | same font (same size, same formatting) the text looks virtually unreadable. I | changed font in some comments and they look much better, but it is extremely | inefficient to try to change font in every new comment I insert, so I thought | maybe there is a way to do it on a default basis. Or maybe I somehow could | change something to make Tahoma appear readable. Please, assist. |
All times are GMT +1. The time now is 05:40 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com