Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005

    Cool Unanswered: Inserting comment in a locked cell

    Hello XLS experts,
    I was wondering if anyone knows how to insert comments into locked cells?

    The reason is I have sensitive information on these cells and do not want others to change them; however I need their inputs and comments on these cells.

    At the moment I can only have one or the other, i.e. either locked or teh ability to inset comments, but NOT both

    Please help!

  2. #2
    Join Date
    Oct 2003
    Howdy, Mags. Couple of questions. If you have XL 2002 (XP) or 2003, then you will be able to do that. When you protect the sheet (Tools > Protect > Protect Sheet), you have the option of allowing what you want the user to be able to do. In this case, Comment is an Excel Object. So, if you scroll to the bottom, you will see the option "Edit object". Make sure that is checked when you protect the sheet. Now someone can insert and edit comments but not the cell itself.
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Sep 2005


    Thank you Shades!
    That was nice and easy!
    Have a good day

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts