comment box keeps getting resized

hi,

i have a worksheet with several comments
ive set it to "show comments"
my problem is everytime i open the file almost all the comments
keeps getting resized where i cant read the comments anymore
id have to resize each comment again just to read the info
even after saving then opening the file again it still gets resized

do you have any idea how to prevent this?

1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.

2. Click Insert > Module, and paste the following macro in the Module window.

VBA code: Auto-size comment boxes in a worksheet

Sub FitComments()
Dim xComment As Comment
For Each xComment In Application.ActiveSheet.Comments
xComment.Shape.TextFrame.AutoSize = True
Next
End Sub

3. Then press F5 key to run this code, and all of the comment boxes in the active worksheet have been resized to fit their contents .

hi,

seemed to have retained the comment box sizes after running the code

thanks!