Modifying format for multiple comments in a workbook
 

Is it possible to mass modify the format for multiple comments (or all
comments) in a workbook? Or do you have to modify every comment
individually? Thnx.

Modifying format for multiple comments in a workbook
 

For a given worksheet:

Sub Verd()
Dim C As Comment
For Each C In ActiveSheet.Comments
With C
.Visible = True
.Shape.Select
Selection.Font.Name = "Verdana"
.Visible = False
End With
Next
End Sub
--
Gary''s Student - gsnu200849


"rmc" wrote:

Is it possible to mass modify the format for multiple comments (or all
comments) in a workbook? Or do you have to modify every comment
individually? Thnx.