Home

One workbook with 1 admin and multiple users on seperate password protected worksheets

%3CLINGO-SUB%20id%3D%22lingo-sub-820160%22%20slang%3D%22en-US%22%3EOne%20workbook%20with%201%20admin%20and%20multiple%20users%20on%20seperate%20password%20protected%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-820160%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%2C%20I%20am%20trying%20to%20create%20an%20hour%20log%20for%20multiple%20employees%20within%20one%20workbook.%20The%20administrator%20would%20have%20access%20to%20the%20entire%20workbook%20and%20then%20employees%20could%20open%20the%20workbook%20but%20would%20only%20be%20able%20to%20view%20their%20individual%20worksheet%20(protected%20by%20their%20own%20password).%20Is%20this%20possible%3F%20Thank%20you.%3C%2FSPAN%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-820160%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826118%22%20slang%3D%22en-US%22%3ERe%3A%20One%20workbook%20with%201%20admin%20and%20multiple%20users%20on%20seperate%20password%20protected%20worksheets%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826118%22%20slang%3D%22en-US%22%3EYour%20best%20bet%20is%20to%20look%20out%20for%20a%20time%20registration%20system%20based%20on%20a%20database%20back-end.%20There%20are%20plenty%20of%20those%20around%20I'm%20sure.%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20insist%20on%20Excel%3A%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20is%20possible%20to%20do%20this%20in%20one%20workbook%2C%20but%20requires%20macro's%20and%20isn't%20very%20secure.%20A%20knowledgable%20person%20would%20be%20able%20to%20view%20other%20people's%20data%20quite%20easily.%20It%20would%20be%20a%20lot%20safer%20to%20have%20a%20separate%20workbook%20for%20each%20person.%20Password%20protect%20those%20files%20with%20a%20file%2C%20open%20password%20you%20only%20hand%20over%20to%20each%20person%20in%20question%20and%20you%20ensure%20people%20wont%20easily%20get%20in%20other%20peoples%20data.%20Even%20better%3A%20let%20IT%20set%20up%20a%20separate%20folder%20on%20a%20network%20drive%20for%20each%20individual%20exclusively%20(and%20accessible%20to%20you)%20and%20put%20their%20files%20in%20there.%20%3CBR%20%2F%3E%3CBR%20%2F%3EAfter%20that%20you%20can%20use%20Data%2C%20Get%20Data%2C%20From%20File%2C%20From%20folder%20to%20fecth%20the%20data%20from%20all%20those%20workbooks%20if%20you%20make%20sure%20the%20layout%20of%20these%20separate%20workbooks%20stays%20exactly%20the%20same.%3C%2FLINGO-BODY%3E
Highlighted
maryroberts
Occasional Visitor

Hello, I am trying to create an hour log for multiple employees within one workbook. The administrator would have access to the entire workbook and then employees could open the workbook but would only be able to view their individual worksheet (protected by their own password). Is this possible? Thank you. 

1 Reply
Your best bet is to look out for a time registration system based on a database back-end. There are plenty of those around I'm sure.

If you insist on Excel:

It is possible to do this in one workbook, but requires macro's and isn't very secure. A knowledgable person would be able to view other people's data quite easily. It would be a lot safer to have a separate workbook for each person. Password protect those files with a file, open password you only hand over to each person in question and you ensure people wont easily get in other peoples data. Even better: let IT set up a separate folder on a network drive for each individual exclusively (and accessible to you) and put their files in there.

After that you can use Data, Get Data, From File, From folder to fecth the data from all those workbooks if you make sure the layout of these separate workbooks stays exactly the same.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies