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.
|