Automatically set conditions, hidden sheets based on user sign in

[The Jade]

I have quite a large workbook with several sheets that talk to each other.

This sheet is updated every once in a while and shared with a team.
The team is divided into 2 main groups(in the future maybe more); admin and regular staff.

Therefore, each group will have access to specific sheets (if a group does not have access to a specific sheet, the latter will be hidden).

Now, the problem that I have is that, everytime I Need to update that data in one of the sheets, I have to save different worksheets based on what group the team members are part of.
This is a bit annoying on the Long run as it requiers a lot of manual work and is prone to mistakes.

To simply things, here are sample sheets:


Home (admin) - Only Admin members have access to
Home (regular) - Only Regular members have access to

Report Admin - Only Admin members have access to
Report Regular - Only Regular members have access to

DB - Both groups have access to it.

At the moment, I have 2 files:
Workbook - Admin (showing only sheets accessible to admin: Home (admin) - Report Admin and DB
Workbook - Regular (showing only sheets accessible to regular: Home (regular) - Report Regular and DB

I would therefore like to have one file, "Workbook", with a Login access.
So, if a member of Admin staff enters their login details, it will automatically show sheets accessible to Admin
Same for Regular.

Is this possible?

 

[mole999]

if you can use the Environ(user) then you can use a case statement from the workbook open event

 

[The Jade]

if you can use the Environ(user) then you can use a case statement from the workbook open event

Thanks....but I have not the slightest idea what that means

Can you elaborate a bit more?

 

[mole999]

Private Sub Workbook_Open()
USER_ID
End Sub

Sub USER_ID()
Dim WHO As String
WHO = Environ("UserName")

CASE
explained here > https://www.techonthenet.com/excel/formulas/case.php

End Sub

CASE basically allows you to test from the user and create a set of instructions to suit the user

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules. Be sure to follow & read the link at the end of the rule too!

Cross posted at: Automatically set conditions, hidden sheets based on user sign in

If you do cross-post in the future and also provide a link, then there shouldn’t be a problem.