• Comments in protected sheets (XP on)

    Author
    Topic
    #426831

    Hi

    I have a worksheet with some complicated formulas that I want to protect using Excel’s sheet protection so that other users can’t overwrite them. Tools>Protect sheet works perfectly except that when I lock the sheet users are also prevented from adding comments to cells that are not locked. The menu option becomes greyed out.

    Can anyone suggest a way round this?

    David

    Viewing 0 reply threads
    Author
    Replies
    • #987401

      When protecting the sheet, tick the check box “Edit objects”. See screenshot.

      • #987438

        Many thanks, Hans. Absolutely what I wanted.

        Intuitive, not!

        Regards
        David

    Viewing 0 reply threads
    Reply To: Comments in protected sheets (XP on)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: