Consulting

Results 1 to 3 of 3

Thread: Solved: Entering Cell Comments On A Protected Worksheet

  1. #1
    VBAX Contributor
    Joined
    Dec 2006
    Posts
    193
    Location

    Solved: Entering Cell Comments On A Protected Worksheet

    Hi Guys ,is it possible to allow users to be able to enter cell comments on a protected work sheet.if so could you please let me know how.

    Thks

  2. #2
    Moderator VBAX Master geekgirlau's Avatar
    Joined
    Aug 2004
    Location
    Melbourne, Australia
    Posts
    1,464
    Location
    You would have to provide a macro to do this: prompt user for their comment text, unprotect the sheet, create the comment, then protect the sheet again.

  3. #3
    VBAX Contributor
    Joined
    Dec 2006
    Posts
    193
    Location
    Thanks for the advice

Posting Permissions

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