• 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: Reply #987401 in 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:




    Cancel