How to run code to change Excel comment font
 

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?


--
lucrosus

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