Excel Comments will not stay as I sized them

Posted on 2011-04-21
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.    
Question by:rschmehl
    LVL 81

    Expert Comment

    by:zorvek (Kevin Jones)
    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


    Author Comment

    I'm telling you "Twisted" dose not come close.  
    LVL 100

    Expert Comment

    No related to Crystal Reports or Misc OS
    Zones removed

    Zone Advisor
    LVL 81

    Accepted Solution


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


    Author Closing Comment

    I have been tryinng to find a solution for about a month and I have come to the same conclusion.
    thank you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
    This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now