Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
=SubField(OSUser(),'\',2)
what is '\',2 ?
what's the value your getting ??
domain/username
SubField() is to get the string which are separated with common value
so =SubField(OSUser(),'\',2)
means to get the second part of \ separator
thank you!
Glad we were able to offer you to resolve