One of the admins on this site, Jerry Beaucaire, wrote a beautiful piece of code that can be used to different password protect every sheet in a range so that a workbook could be theoretically shared without any of the regular users being able to see any other users' data.
A master password would then be able to see everything. Here's the link to master Beaucaire's sample file.
https://sites.google.com/a/madrocket...edirects=0&d=1
Using the admin password, you would just create a password for each users and put the tab name they have access to. You then have a summary tab where all the user tabs feed into.
Bookmarks