Learn how to a build a cloud-first strategyRegister Now

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

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.    
0
rschmehl
Asked:
rschmehl
  • 2
  • 2
1 Solution
 
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
 
zorvek (Kevin Jones)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
 
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

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!

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