Hide sheets in work book that can be accessed by different teams using a password

[Nikijune]

Hi,

I'm not sure if this is possible, but I'm hoping there is some VBA that could help me.

I have a spread sheet that will hold summary pages for 4 different teams. I don't want each team to be able to see each others summaries, so I want to hide all of the sheets, and maybe have a front end user input where they go in and say which sheet they want to see, and then put in a unique password for their sheet for it to appear.

Is this possible??

Thanks in advance

 

[dmt32]

Hi,
Another way to manage your requirement is via a table with user’s names & sheets they have access to. Access to sheets would be automatic (no passwords needed) as you would check valid users against their network Username.

Have a look here:https://www.mrexcel.com/forum/excel...word-protect-viewing-multiple-worksheets.html

With a solution I helped another with & see if could work for your project.

Dave