Password protect worksheets to Individuals


March 12th, 2013 by Dave Hartshorne

Hi

I use a work book to keep a record of each staff members holiday records.
Work book comprises of a master sheet which collates entitlement and remaining hours for each staff member (linked from their individual worksheet)
Each staff members records are recorded on a desperate worksheet named as a number. 1, 2, 3 etc

The workbook is protected to read only for staff, but all staff members can view each others records.

What I want to achieve is to set up individual passwords for each staff member so that when opening the workbook they can only see their worksheet. But, also set so that I can open all worksheets with only entering one password and not having to use staff members individual passwords to update their records.

Hopefully not a mamouth task.

Regards

Dave

3 Responses to “Password protect worksheets to Individuals”

  1. BenneTan BenneTan Says:

    hi Dave, see if the file below works for you. The Username & Password for you is:
    Username: Admin
    Password: Admin

    You’ll be able to see a sheet named “User List”. That will enable you to grant access to different people with access to different sheets. As you can see, Admin has access to all the sheets (marked with an “x”).

    http://www.excel-course.com/wp-content/uploads/2013/03/20130313-Usernames-Passwords_v2.xls

  2. Dave Hartshorne Says:

    BenneTan

    Thanks for that its much appreciated.
    Another factor has come into the equation, can it be set so that when a user logs on through their password the only open it in read only. But if an administrator opens it they get write access. Or is this going a step too far?

    This again

    Dave

  3. BenneTan BenneTan Says:

    so in the codes, I might have to say something like “If Username is not equals to Admin, then put as Read-Only”. is that ok? or maybe you can fix a cell reference in “User List” under column A that belongs to the Admin. for eg, A4 will always contain the Username of the Admin.

    but just to clarify, Excel is not meant to be security tight. I hope all these actions are just to prevent accidental entries, not to hide confidential stuffs.

Leave a Reply

You must be logged in to post a comment.

s2Member®