comment font size

[Guloluseus]

A colleague has an excel worksheet where many cell shave attached comments (as in hover over and they will pop up). these are generally too small to read, and he would ideally like to change the size of the comment font to a larger one. There are several 100, if not thousands, of commented cells, and we really need a global change to the comment font size.
Does anyone know if this can be done, and if so how?


thanks.

[Catalin.B]

You must run a macro to do this, there are several formats you can change in a comment's font:

Sub ChangeCommentTextFormat()
    For Each Coment In ActiveSheet.Comments
        With Coment.Shape.TextFrame.Characters.Font
            .Name = "Arial Bold" '"Times New Roman"
            .Size = 11
            .Bold = False
            .ColorIndex = 0
        End With
    Next Coment
End Sub

[Guloluseus]

Perfect thank you

Much appreciated.