Consulting

Results 1 to 3 of 3

Thread: Allowing validation on protected sheet

  1. #1

    Allowing validation on protected sheet

    Hi, I have a sheet that is protected, but I have 2 cells that have a validation list on them. Is it possible to allow these 2 cells to be edited? or allow the validation on the worksheet?

    Thanks,

    john.

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Yes you can "unprotect" the 2 cells in question.
    You may also be able to use Tools>Protection>Allow users to edit ranges
    if you have Excel 2000 or later.

  3. #3
    Thank you, I should have really known this! hehe.

    Appreciate the help.

Posting Permissions

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