conditional hide based on user

[denis115]

Hello !

Help me pease !

What condition I must put in sheet properties to achieve what I want?

I need to hide a sheet from only one user , another users must see this sheet, how can I do this?

Thanks !

I'm using ntname section  access.

I find a condition but it doesnt hepled me: if(osuser()='ntname',1,0)

[denis115]

=SubField(OSUser(),'\',2)

what is    '\',2   ?

[avinashelite]

what's the value your getting ??

[denis115]

domain/username

[avinashelite]

SubField() is to get the string which are separated with common value

so  =SubField(OSUser(),'\',2)

means to get the second part of \ separator

[denis115]

thank you!

[Anil_Babu_Samineni]

Glad we were able to offer you to resolve