Excel Comments will not stay as I sized them

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.    
Who is Participating?
zorvek (Kevin Jones)Connect With a Mentor ConsultantCommented:

"You can't do what you want" is as valid a solution as "here is how to do what you want".

Excel's comment function has always had this issue. There are workarounds but they involved work.

zorvek (Kevin Jones)ConsultantCommented:
The dude who coded the comment box function has a very twisted sense of humor.

Here is a discussion on the situation and some possible solutions:

Title: Fix size and position of comment
Link: http://www.excelbanter.com/showthread.php?t=229201

rschmehlAuthor Commented:
I'm telling you "Twisted" dose not come close.  
No related to Crystal Reports or Misc OS
Zones removed

Zone Advisor
rschmehlAuthor Commented:
I have been tryinng to find a solution for about a month and I have come to the same conclusion.
thank you
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.