Restrict access to excel sheets

[helplessnoobatexcel]

Hi guys, I would like to draft out a macro code to restrict access to certain sheets in excel to users but I am currently stuck in writing the code. PLS HALP T_T. Example, a shared excel notebook in which users can only view & edit their designated sheets and main users are given full access to view & edit all the sheets in the workbook. Alternatively, a code for password protecting the sheets would be good too! Many thanks >0<

 

[Joe4]

Welcome to the Board!

Not sure if this is what you are looking for, but you can protect each sheet with a password, and just give users the passwords to the sheets they should have access to.
If you want to protect/unprotect the sheet with VBA code, see here: How to PROTECT and UNPROTECT a Sheet using VBA in Excel

 

[helplessnoobatexcel]

Welcome to the Board!

Not sure if this is what you are looking for, but you can protect each sheet with a password, and just give users the passwords to the sheets they should have access to.
If you want to protect/unprotect the sheet with VBA code, see here: How to PROTECT and UNPROTECT a Sheet using VBA in Excel

Hi, thanks Joe for your reply!
I've read the article you posted and it has helped me understand alot more about the code! I have tried it out, however I realised it's too tedious to encrypt each sheet individually I have a large number of sheets in my excel file. Any ideas on how I can do so? Thanks in advance!!

 

[Joe4]

So, every single sheet would be for a different user, who should have their own password?
If so, I am not sure how you get around the "tedious-ness" issue, as it appears to be a more logistical issue (the "nature of the problem/situation"), and not really an Excel issue. Excel is just the tool you are trying to use the solve the issue.

Also something else to consider - Excel is not known for being very secure. Excel secure is pretty easy to break for anyone willing to do a little research on the internet.
So if security is important and it is absolutely critical that members should only be able to see their own sheets and no one else's, Excel is probably not the best choice here.

 

[helplessnoobatexcel]

So, every single sheet would be for a different user, who should have their own password?
If so, I am not sure how you get around the "tedious-ness" issue, as it appears to be a more logistical issue (the "nature of the problem/situation"), and not really an Excel issue. Excel is just the tool you are trying to use the solve the issue.

Also something else to consider - Excel is not known for being very secure. Excel secure is pretty easy to break for anyone willing to do a little research on the internet.
So if security is important and it is absolutely critical that members should only be able to see their own sheets and no one else's, Excel is probably not the best choice here.

I see. Thanks Joe for your help so far.