Free Support Forum -

Too many Comment Font

I am getting an error with Comments. I am inserting a comment for each row in the workbook, and there are several hundred rows. I would like to have the comment formatted in "Courier New" font, which I set when I create the comment.

Unfortunately, this exceeds the number of fonts allowed in Excel. I think each time you set a font property in a comment, it eats up a font object.

There doesn't seem to be a way to share the font settings between comments, or point to a shared style? The font property in the comment is read only.

Is there a workaround, or could the comment object be extended to share a font object?

Mitch Stephens

Hi Mitch,

I will check and fix this issue ASAP.