WeThotUWasAToad
asked on
Password protect individual worksheets in Excel
Hello,
Is there a way to password protect individual worksheets in an Excel workbook?
For example, I have several employees who, up to this point, have been signing-in and signing-out by hand on a printed timesheet. However, a couple of problems have recently arisen due to employees being able to see other employees' hours.
I'd like to be able to create a simple time chart in Excel where each employee has their own password-protected sheet tab so they can login to enter their times but not have access to any other employee's information.
Is that doable?
Thanks
Is there a way to password protect individual worksheets in an Excel workbook?
For example, I have several employees who, up to this point, have been signing-in and signing-out by hand on a printed timesheet. However, a couple of problems have recently arisen due to employees being able to see other employees' hours.
I'd like to be able to create a simple time chart in Excel where each employee has their own password-protected sheet tab so they can login to enter their times but not have access to any other employee's information.
Is that doable?
Thanks
ASKER
Thanks for the reply Roy.
1) How do you bring up the login box when it is not present?
2) How does a user change their password?
3) How do you assign a password to the Manager?
4) How does the manager create new users?
5) When creating a new worksheet, how do you designate which users can access it?
6) How can all existing sheet tabs be viewed simultaneously by the Manager?
7) What do the "Level" numbers refer to?
8) What is the difference between Hidden & VeryHidden?
Thanks
I think what you need in addition to this is to hide all the workers' sheets so that only each individual can open his/her sheet.Yes, that is exactly what I am after as stated in the OP:
I'd like to be able to create a simple time chart in Excel where each employee has their own password-protected sheet tab so they can login to enter their times but not have access to any other employee's information.Regarding your attached file:
1) How do you bring up the login box when it is not present?
2) How does a user change their password?
3) How do you assign a password to the Manager?
4) How does the manager create new users?
5) When creating a new worksheet, how do you designate which users can access it?
6) How can all existing sheet tabs be viewed simultaneously by the Manager?
7) What do the "Level" numbers refer to?
8) What is the difference between Hidden & VeryHidden?
Thanks
ASKER
Also, in the worksheet named "Hide this sheet", there is a statement which says:
"Use the multi user button for the table below"
What is the "multi user button" and what does this statement mean?
"Use the multi user button for the table below"
What is the "multi user button" and what does this statement mean?
The userform displays when the workbook is opened, I'll add a button to open as well.
The line should refer to the manage button the form. I'll just tweak the workbook and code a little
The line should refer to the manage button the form. I'll just tweak the workbook and code a little
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Did this work for you?
Is this working as you want now?
No further comment from the author.
Protect a worksheet
However, I think what you need in addition to this is to hide all the workers' sheets so that only each individual can open his/her sheet. The manager would be able to access all.
This workbook allows that.
PASSWORD-FORM-7.xlsm