Hiding sheets in QVW

[Anonymous]

Hello,

I need to hide sheets in the access points for 5 users. I'm using the syntax =if(osuser() = 'EXCHANGE\ABC',0,1) under sheet properties > General > Conditional. It works well in the Access point that the user ABC can no longer see the tab/sheet.

My question is regarding how to implement the same logic for other 4 users within the same syntax. Can we use =if(osuser() = 'EXCHANGE\ABC', 'EXCHANGE\DEF', 0,1). What is the correct way of implementing it.

[sergio0592 · Accepted solution]

Hi, try with :

=if(match(osuser(), 'EXCHANGE\ABC', 'EXCHANGE\DEF')>0,0,1)

But in OS user name there is often differents case letter eg Jason_COOPER, Brenda_Trafford. So i often use mixmatch() function instead.