Home

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
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

HI @Deleted 

 

That would require some complex VBA programming to set up

 

It's not possible with standard Excel functionality

Hi@Wyn Hopkins 

 

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

 

Thanks

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.
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
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)

Hi@Wyn Hopkins 

 

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

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
201 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies