• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Password protected workbooks

kevinonearth

kevinonearth

Member
Hi,

I am creating an attendance sheet for staff for 2013


Each staff member must enter their hours for each week of the year in their individual workbook.

Each staff member's workbook is linked to a master workbook where the manager can see at a glance who is in, who is out and when people plan to take annual leave.

Each staff member's workbook is password protected so that only they are responsible for it's contents.

Problem is when I open the master workbook it asks me for the password for each individual staff member.


How do I set up my linked workbooks so that each individual staff member's workbook is protected but the manager's master workbook is open and not password protected?


Thank you
 
*This solution would be a trade-off*


You could change all the staff memeber workbooks so that they are simply worksheet protected. Staff then enters password to change the worksheet. Boss workbook can now read all the staff files w/o needing a password. Trade-off is that this is a slight decrease in protection for the staff files. I'm not sure how secure you needed them to be.
 
Hi Luke,

I would need the individual staff workbooks to be secure

Do you know if it is possible to password protect folders in Windows and place each staff member's workbook in a password protected folder?
 
Hi, kevinonearth!

Excel isn't secure. Well, absolutely secure. If you need full security you'd think of changing the platform.

Give a look at this link:

http://chandoo.org/forums/topic/macro-to-hideunhide-in-protected-sheet-produces-error-code#post-37901

And don't be afraid, go on using Excel, but be aware of the lack of lawless security.

Regards!
 
Ideally, you would have your IT Admin setup a folder for each staff member. Then give each staff member read/write access to their respective folder, but the manager has read(maybe write?) access to all folders. Depending on your Admin and size of company, I'm not sure if this is really a viable option or not.
 
You must log in or register to reply here.
Back
Top