[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

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.
0
rschmehl
Asked:
rschmehl
  • 7
  • 5
1 Solution
 
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
 
KnutsonBMCommented:
what is the text supposed to look like and what does it change back to?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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 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:
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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 7
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now