+ Reply to Thread
Results 1 to 8 of 8

Users with different permissions

  1. #1
    Registered User
    Join Date
    06-12-2009
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2010
    Posts
    68

    Users with different permissions

    Is it possible to have a locked spreadsheet that allows different unlocked cells depending on the user?

    so for me it would be all unlocked,

    user 2 would be column 2 unlocked, all else locked

    user 3 would be column 3 unlocked, all else locked

    etc, etc.

    thanks
    Last edited by 1.zer0; 09-02-2009 at 08:01 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Users with different permissions

    A few approaches, one is to base things off the NT username of the current user - the below would reside in ThisWorkbook Object in VBE:

    Please Login or Register  to view this content.
    Should give you something to work from... you would of course need to ensure Macros are enabled for this to work and/or ensure all cells are locked when the file is opened initially.
    Last edited by DonkeyOte; 09-02-2009 at 07:21 AM.

  3. #3
    Registered User
    Join Date
    06-12-2009
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2010
    Posts
    68

    Re: Users with different permissions

    thanks donkey, although i'm not entirely sure what i do with the code you just gave me!!

    just to give you a little more info, the spreadsheet would be held on my website and people would connect through that. so i think the NT username wouldn't work?

    it will hopefully go like this:

    someone logs onto my website and downloads the spreadsheet, makes amendments to only the section they are allowed (like the column example i gave) then they would upload it back to the website for others to do the same.

    long winded i know but for my purpose this is the only way i can think of doing it for now.

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Users with different permissions

    So given you have no idea who's downloaded your file how exactly do you intend to differentiate the access privileges ???

    I think this is a non-starter unless you go down the route of some sort of IP based approach... out of my knowledge base.

  5. #5
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    6,997

    Re: Users with different permissions

    Quote Originally Posted by 1.zer0 View Post
    someone logs onto my website and downloads the spreadsheet, makes amendments to only the section they are allowed (like the column example i gave) then they would upload it back to the website for others to do the same.
    What happens if the second person downloads the spreadsheet BEFORE the first person has uploaded his amendments? Any changes made by the first user will be lost when the second user overwrites the file.

    I would have thought separate spreadsheets for each use would be the best method. Then some form of macro to accumulate them together which might be what DonkeyOte was heading towards. This would assume no user needs to accesss another's data.
    Last edited by Special-K; 09-02-2009 at 07:54 AM.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  6. #6
    Registered User
    Join Date
    06-12-2009
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2010
    Posts
    68

    Re: Users with different permissions

    OK fair enough. i wonder if there's a way i can do it PHP based? i'll have a mooch.

    the users would log onto my website to download it so there must be some form of verification there.

  7. #7
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Users with different permissions

    Well yes that's true but the verification is taking place on the web client rather than in XL environment... if using php you might want to think about using a database (MySQL) and web form for the data entry rather than a spreadsheet.

  8. #8
    Registered User
    Join Date
    06-12-2009
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2010
    Posts
    68

    Re: Users with different permissions

    ok thanks guys.

    i think i'll look into the individual users spreadsheets before i go into SQL!

+ 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