We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Comments In Excel do not stay the size i created

rschmehl
rschmehl asked
on
Medium Priority
234 Views
Last Modified: 2012-05-11
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.
Comment
Watch Question

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

Author

Commented:
I am using excel 2007 sp2.  
Boggy.xls
what is the text supposed to look like and what does it change back to?
i am seeing them in Georgia-Bold-size 8 font

Author

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
i dont see anything cut off, could you provide a screen shot?

Author

Commented:
Screen shot of coment when you open for edit. The same thing happens when you hover over
sc1.bmp
.........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

Author

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??
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
you can change the width and height to one size that can work for all comment boxes

Author

Commented:
thanks for the help
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.