This is a macro that changes the font and font size in comments in the
active workbook. A couple of periods have fallen off though -- you can
see the original code he
http://groups.google.com/groups?hl=e...turesXSPAM.com
There are instructions here for copying the code to your workbook:
http://www.contextures.com/xlvba01.html
David McRitchie has instructions for getting started with macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
lucrosus wrote:
This is what I have found so far,
'======================
Sub FormatAllComments()
Dim ws As Worksheet
Dim cmt As Comment
For Each ws In ActiveWorkbook.Worksheets
For Each cmt In ws.Comments
With cmt.Shape.TextFrame.Characters.Font
Name = "Verdana"
Size = 12
End With
Next cmt
Next ws
End Sub
'========================
Some questions. 1. What is this? 2. How do I use this?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html