+ Reply to Thread
Results 1 to 4 of 4

Protect sheet with 2 or more password

  1. 05-02-2012, 06:06 AM #1
    iazis
    iazis is offline
    Registered User
    Join Date
    04-23-2012
    Location
    Indonesia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Protect sheet with 2 or more password

    Hello, I'm Iazis and still fresh in this forum.
    I have a problem managing a spread sheet which using 3 by different users from 3 different sections where each section shall input data in a specific colums and will responsible for correctness of the data they inputted.
    In order to protect wrong or illegal data, I protect the sheet with a password sharing to all users. But it can not help as I can not trace who input wrong or illegal data.
    Can someone help me how to protect the sheet using 2 or more password for specific columns.
    Thanks.
    Reply With QuoteRegister To Reply
  2. 05-02-2012, 06:13 AM #2
    abousetta
    abousetta is offline
    Forum Guru
    Join Date
    03-12-2010
    Location
    Canada
    MS-Off Ver
    2010 and 2013
    Posts
    4,418

    Re: Protect sheet with 2 or more password

    Hello and welcome to the forum.

    This section is only for introductions. Please PM one of the moderators to move this thread to one of the other forum groups so that if a member is interested in this topic, or aware of a solution, they can help you.

    Good luck.

    abousetta
    Please consider:

    Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
    Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
    Reply With QuoteRegister To Reply
  3. 05-02-2012, 06:24 AM #3
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Protect sheet with 2 or more password

    Thread moved.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
  4. 05-02-2012, 07:07 AM #4
    john55
    john55 is offline
    Valued Forum Contributor john55's Avatar
    Join Date
    10-23-2010
    Location
    Europe
    MS-Off Ver
    Excel for Microsoft 365
    Posts
    2,028

    Re: Protect sheet with 2 or more password

    hi!
    ChemistB and Dominic provided solutions! see here http://www.excelforum.com/excel-gene...readsheet.html
    Regards, John55
    If you have issues with Code I've provided, I appreciate your feedback.
    In the event Code provided resolves your issue, please mark your Thread as SOLVED.
    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

    ...enjoy -funny parrots-
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1