Show / Hide specific sheets per username

Hi all,

I'm trying to only show specific sheets per user using the environ variable and this code seems to work for the single user / sheet but the master user does not function correctly i.e. the code does not show all sheets, this is the code I am using:

Please Login or Register  to view this content.

Does anyone know why the above code does not respect the Master User "Jane" should be able to see all sheets?

---

Original source for this code was found here:

HTML Code: 

I have not checked the rest ** the code, but if it works with other users, just add the blue parts to show all sheets to Masteruser

Please Login or Register  to view this content.

First question is about Jane ;-)
Have you tried:

Please Login or Register  to view this content.

Does it show exactly

HTML Code: 

if not - correct the code.
May be Ucase or Trim is needed.

Sorry to say so - the problem is not just with the code - it is probably elsewhere.
You have shown no sample workbook so hard to judge.
Try the attached and compare yourself the differences.

I am glad to hear that. It is good time to mark thread as solved.
See http://www.excelforum.com/forum-rule...rum-rules.html how to do it.