Hi,
maybe you can add to your workbook simple macro that will make all comments to fit it's content.
Or if you want them all to have specific size it can be also option..![]()
Sub AutosizeComments() Dim yourComments As Comment For Each yourComments In Application.ActiveSheet.Comments yourComments.Shape.TextFrame.AutoSize = True Next End Sub
That's I guess what I would do if some comments would drive me crazy, so just an idea
Good luck.
Bookmarks