Show / Hide specific sheets per username

[byte]

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:

[Kaper]

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.

[byte]

Hi Kaper,

Thanks but this doesn't affect anything i.e. doesn't respect the master user chosen.

[Kaper]

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

Please Login or Register  to view this content.

Does it show exactly

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

[byte]

Hi Kaper,

Thanks again for your reply. Yes, I have double, triple checked the username and it does show Jane, I have also tried with UCase...

Please Login or Register  to view this content.

But the code still does not show all sheets to master user

[Kaper]

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.

[byte]

Thanks Kaper, not sure how or why but I copied the code from your sample (sorry about the no sample on my side) and this worked in my workbook...again I am not so sure why but maybe I had a slight code error in my original :~

Thanks again Kaper

[Kaper]

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.