Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243

    Unanswered: Protect Excel based on domain users

    Hello,

    I was asked how an excel-sheet can be protected. I played around with password-protection and that is working fine. But what I want to achieve is securing the file based on the username.
    In Active Directory I created a group and assigned some users to it.
    In Excel, I created a range an selected this group to grant access to the range.
    I protect the workbook.
    When testing, everyone is still able to edit the cells.
    I searched the internet and there was mentioned that you should fill in a password, else everyone can edit the cell.
    My question is : What are user(groups) for if you still need an additional password to get the range protected?
    Is there any possibility to have my ranges protected just by username and without password?

    Thanks

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy. Do you need for them to be able to see the data, but not access it? Or do you want hidden rows/columns?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243
    Hi,

    Thanks for answering.
    Currently we have an excel file to track all our projects.
    These projects do have milestones which should be approved by certain people. Obviously person A can not approve milestone of person B.
    Therefor I have 2 columns. Column A can only be edited by Person A en column B only by Person B.
    That's what I need it for.

    You have any idea?

    Thanks

  4. #4
    Join Date
    Oct 2003
    Posts
    1,091
    One further question. Does Person A need to see Column B, even though he/she cannot edit it?
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  5. #5
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243
    Everyone can see the content of all cells.

Posting Permissions

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