+ Reply to Thread
Results 1 to 2 of 2

How do I create a comment on an unlocked cell in a protected sheet

Hybrid View

  1. #1
    LObeidat
    Guest

    How do I create a comment on an unlocked cell in a protected sheet

    Am not able to create a comment on an unlocked cell in a protected sheet.
    Creating comments is not one of the features I can enable when protecting the
    sheet. Please advise if you've faced/solved this problem before.

  2. #2
    Dave Peterson
    Guest

    Re: How do I create a comment on an unlocked cell in a protected sheet

    Unprotect your worksheet
    tools|protection|protect sheet

    You'll see an object to allow the user to edit Objects (phrasing/location
    changes with versions of excel). Make sure you allow this.

    and continue with the protection.

    Remember that when you allow comments, you're also allowing the users to change
    other objects, too--shapes/buttons/pictures....

    LObeidat wrote:
    >
    > Am not able to create a comment on an unlocked cell in a protected sheet.
    > Creating comments is not one of the features I can enable when protecting the
    > sheet. Please advise if you've faced/solved this problem before.


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1