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

"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.

Kevin
0
 
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

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

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