How to prevent individual sheets from being viewed with INDIVIDUAL passwords?

[mSolver]

Say there are 10 teams using the same workbook. There are 10 worksheets inside, and I only want each team to be able to view & access their own worksheet.

Most solutions I saw only allow me to protect the entire workbook, not individual worksheets from being viewed.

Hope to see some suggestions without using 3ʳᵈ party extensions. Thanks!

 

[dmt32]

Hi,

Have a look at this article here:Excel Userform Login - Online PC Learning

And see if will do what you want.

Do be aware though that Excel security is weak & suggested solution can be easily bypassed by those with a reasonable grasp of the workings of excel.

Dave