Comments In Excel do not stay the size i created

I have a spread sheet which has some VBA code and it is saved as a xls file. This spread sheet also has Comments which pop up when you hover with the cursor. I have protected the whole file and locked the comments with the comment formatter.  But when i save and reopen the comments are different sizes and do not show the text correctly.
I've gone crazy already but if any knows why this happens.
rschmehlAsked:
Who is Participating?
 
KnutsonBMCommented:
you can use VBA to resize the comment boxes, the following is from Q_20625222 answered by mesclun

Sub ResizeComments()
    Dim ws As Worksheet, c As Comment
    For Each ws In ActiveWorkbook.Worksheets
        For Each c In ws.Comments
            c.Visible = True
            c.Shape.Width = 130.5
            c.Shape.Height = 126
            c.Visible = False
        Next
    Next
End Sub
0
 
KnutsonBMCommented:
can you post a copy of the workbook you are using?  What version of excel are you using?  I have xl2007 and when i saved, closed, and re-opened, the comments stayed the same size.....

brandon
0
 
rschmehlAuthor Commented:
I am using excel 2007 sp2.  
Boggy.xls
0
Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

 
KnutsonBMCommented:
what is the text supposed to look like and what does it change back to?
0
 
KnutsonBMCommented:
i am seeing them in Georgia-Bold-size 8 font
0
 
rschmehlAuthor Commented:
If you hover over line 25 or so you'll see some of the text cut off n the comment when it pops up.  I have sized these several time aand when i close and re open they change. If you open the comet ffor edit you can see  the whole text
0
 
KnutsonBMCommented:
i dont see anything cut off, could you provide a screen shot?
0
 
rschmehlAuthor Commented:
Screen shot of coment when you open for edit. The same thing happens when you hover over
sc1.bmp
0
 
KnutsonBMCommented:
.........i resized it, saved, closed.......it showed everything........so i closed completely out of excel, reopened it......and it still stayed resized...................
Copy-of-Boggy-1.xls
0
 
rschmehlAuthor Commented:
Wow, I just opened the file you sent back and it looks exacly the same, comments are not correct.  So could his be a proplem wiith my version of excel  or possible a missing update??
0
 
KnutsonBMCommented:
you can change the width and height to one size that can work for all comment boxes
0
 
rschmehlAuthor Commented:
thanks for the help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.