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

    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!
    Cheers
    Mags

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    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!

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

    How to ask a question on forums

  3. #3
    Join Date
    Sep 2005
    Posts
    2

    Thanks

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

Posting Permissions

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