Setting permissions to different users to access different spreadsheets within the same workbook

%3CLINGO-SUB%20id%3D%22lingo-sub-545382%22%20slang%3D%22en-US%22%3ESetting%20permissions%20to%20different%20users%20to%20access%20different%20spreadsheets%20within%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-545382%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20set%20permissions%20to%20different%20users%20to%20access%20different%20spreadsheets%20within%20the%20same%20Excel%20workbook.%20For%20example%2C%20user%20A%20will%20be%20able%20to%20access%20'Overall'%20and%20'A'%20spreadsheets%20but%20not%20'B'%20spreadsheet.%20User%20B%20will%20be%20able%20to%20access%20'Overall'%20and%20'B'%20spreadsheets%20but%20not%20'A'.%20Would%20greatly%20appreciate%20any%20advice%20on%20how%20to%20achieve%20this%20function%2C%20thank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20203px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F112545iC5B0F7B3BA87EB90%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Capture1.JPG%22%20title%3D%22Capture1.JPG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-545382%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-545537%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20permissions%20to%20different%20users%20to%20access%20different%20spreadsheets%20within%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-545537%22%20slang%3D%22en-US%22%3E%3CP%3EHI%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F337824%22%20target%3D%22_blank%22%3E%40Zane_Aw%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat%20would%20require%20some%20complex%20VBA%20programming%20to%20set%20up%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt's%20not%20possible%20with%20standard%20Excel%20functionality%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-562085%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20permissions%20to%20different%20users%20to%20access%20different%20spreadsheets%20within%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562085%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWould%20you%20know%20where%20can%20I%20find%20the%20vba%20code%20to%20set%20up%20this%20function%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-562117%22%20slang%3D%22en-US%22%3ERe%3A%20Setting%20permissions%20to%20different%20users%20to%20access%20different%20spreadsheets%20within%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562117%22%20slang%3D%22en-US%22%3EI%20just%20googled%20and%20found%20this%20article%20%3CBR%20%2F%3E%3CA%20href%3D%22http%3A%2F%2Fwww.vbaexpress.com%2Fforum%2Fshowthread.php%3F40194-Un-protect-sheet-for-specific-user%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.vbaexpress.com%2Fforum%2Fshowthread.php%3F40194-Un-protect-sheet-for-specific-user%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI'd%20only%20advise%20doing%20this%20if%20you%20have%20good%20VBA%20experience%2C%20and%20if%20the%20data%20isn't%20too%20sensitive.%20Excel%20sheet%20protection%20is%20not%20particularly%20strong.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-562241%22%20slang%3D%22en-US%22%3ERE%3A%20Setting%20permissions%20to%20different%20users%20to%20access%20different%20spreadsheets%20within%20the%20same%20workbook%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562241%22%20slang%3D%22en-US%22%3EHi%20Wyn%20Hopkins%2C%20Thank%20you%20for%20your%20reply.%20Unfortunately%2C%20the%20data%20I'm%20handling%20is%20quite%20sensitive..%20Do%20you%20have%20any%20software%20to%20recommend%3F%20I'm%20doing%20up%20a%20project%20management%20tracking%20system%20where%204%20users%20will%20be%20involved%20and%20my%20team%20will%20oversee%20the%20entire%20process%20and%20have%20admin%20rights.%20My%20main%20concerns%20are%20to%20set%20different%20levels%20of%20access%20and%20they%20can%20only%20view%20and%20modify%20the%20spreadsheet%20they%20are%20supposed%20to%20edit%2C%20not%20be%20able%20to%20view%20other%20spreadsheets.%20My%20team%20will%20have%20the%20overall%20rights%20to%20view%20and%20modify%20(if%20need%20be)%20the%20file.%20Thanks%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-562254%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Setting%20permissions%20to%20different%20users%20to%20access%20different%20spreadsheets%20within%20the%20same%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562254%22%20slang%3D%22en-US%22%3EHi%20%3CBR%20%2F%3EThere%20are%20techniques%20using%20VBA%20that%20can%20make%20it%20very%20difficult%20for%20people%20to%20access%20certain%20sheets%20but%20you%20need%20some%20experienced%20in%20VBA%20to%20get%20it%20to%20work%20really%20well.%20%3CBR%20%2F%3E%3CBR%20%2F%3EIf%20you%20have%20O365%20then%20something%20like%20SharePoint%20could%20be%20an%20option%20(not%20an%20expert%20in%20that%20area%20but%20maybe%20post%20on%20the%20SharePoint%20community%20forum)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-562529%22%20slang%3D%22en-US%22%3ERe%3A%20RE%3A%20Setting%20permissions%20to%20different%20users%20to%20access%20different%20spreadsheets%20within%20the%20same%20work%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-562529%22%20slang%3D%22en-US%22%3E%3CP%3EHi%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F9832%22%20target%3D%22_blank%22%3E%40Wyn%20Hopkins%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOk%20I%20will%20enquire%20in%20the%20SharePoint%20community%20forum%2C%20appreciate%20the%20help%20rendered!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

Hi all,

 

I am trying to set permissions to different users to access different spreadsheets within the same Excel workbook. For example, user A will be able to access 'Overall' and 'A' spreadsheets but not 'B' spreadsheet. User B will be able to access 'Overall' and 'B' spreadsheets but not 'A'. Would greatly appreciate any advice on how to achieve this function, thank you!

 

Capture1.JPG

 

6 Replies
Highlighted

HI @Deleted 

 

That would require some complex VBA programming to set up

 

It's not possible with standard Excel functionality

Highlighted

Hi@Wyn Hopkins 

 

Would you know where can I find the vba code to set up this function?

 

Thanks

Highlighted
I just googled and found this article
http://www.vbaexpress.com/forum/showthread.php?40194-Un-protect-sheet-for-specific-user

I'd only advise doing this if you have good VBA experience, and if the data isn't too sensitive. Excel sheet protection is not particularly strong.
Highlighted
Hi Wyn Hopkins, Thank you for your reply. Unfortunately, the data I'm handling is quite sensitive.. Do you have any software to recommend? I'm doing up a project management tracking system where 4 users will be involved and my team will oversee the entire process and have admin rights. My main concerns are to set different levels of access and they can only view and modify the spreadsheet they are supposed to edit, not be able to view other spreadsheets. My team will have the overall rights to view and modify (if need be) the file. Thanks
Highlighted
Hi
There are techniques using VBA that can make it very difficult for people to access certain sheets but you need some experienced in VBA to get it to work really well.

If you have O365 then something like SharePoint could be an option (not an expert in that area but maybe post on the SharePoint community forum)
Highlighted

Hi@Wyn Hopkins 

 

Ok I will enquire in the SharePoint community forum, appreciate the help rendered!