comment font size

Guloluseus · #1 07-03-2013, 01:21 AM

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 · #2 07-03-2013, 01:37 AM

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

Code:

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 · #3 07-03-2013, 09:14 AM

Perfect thank you

Much appreciated.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Font Size	cjpga	Outlook	1	04-13-2013 06:45 AM
how change size font to inches size	kkepo	Word	4	08-28-2012 08:53 PM
Cursor size varies with font size	r_lewis@fuse.net	Word	0	07-20-2011 06:11 PM
Font Size	iflog	Outlook	1	11-30-2010 09:33 PM
Font Size & Colour	yparuk	PowerPoint	0	10-07-2010 12:37 AM