locked
Excel - Can't insert comments in unlocked cell of protected worksheet RRS feed

  • Question

  • I have created a spreadsheet with certain cells that are unlocked, through use of (format cells, protection, then no check box on locked). Then I protect the spreadsheet. While data can then be inserted into the unlocked cells a comment cannot be added to the cell. I 'm running Windows 7, Office 10.

     

    Friday, June 3, 2011 6:18 PM

Answers

  • Excel 2002 (Office XP), right.

    When you protect the sheet, make sure you allow the users to "edit objects".

    Be aware that this allows them to edit all objects -- not just comments.

    If that's open, you may want to provide them with a macro that gets the comment
    text, unprotects the sheet, inserts the comment, and reprotects the sheet.

    Wants, to, Learn wrote:


    I have created a spreadsheet with certain cells that are unlocked, through use of (format cells, protection, then no check box on locked). Then I protect the spreadsheet. While data can then be inserted into the unlocked cells a comment cannot be added to the cell. I 'm running Windows 7, Office 10.

    --

    Dave Peterson

    Saturday, June 4, 2011 11:04 AM

All replies

  • Hi

    By 10 you mean 2010 or 2002. The Comment is an Object and using default protection this feature becomes locked.  If you mean 2010 then your in luck because you can apply sheet protection and allow the editing of objects (near the bottom of the list).  It's worth noting that any shapes or charts will also remain unlocked too.

    Hope this helps.


    G North MMI
    Friday, June 3, 2011 6:55 PM
  • Excel 2002 (Office XP), right.

    When you protect the sheet, make sure you allow the users to "edit objects".

    Be aware that this allows them to edit all objects -- not just comments.

    If that's open, you may want to provide them with a macro that gets the comment
    text, unprotects the sheet, inserts the comment, and reprotects the sheet.

    Wants, to, Learn wrote:


    I have created a spreadsheet with certain cells that are unlocked, through use of (format cells, protection, then no check box on locked). Then I protect the spreadsheet. While data can then be inserted into the unlocked cells a comment cannot be added to the cell. I 'm running Windows 7, Office 10.

    --

    Dave Peterson

    Saturday, June 4, 2011 11:04 AM