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]

it also doesnt work

[denis115]

Its to hard for me to understand what I have to do with all this, of course I understand that when you give 1 or 0 to a sheet but for what do we need this? :

Sheet_Security:

LOAD USERS as NM,

     SH01,

     SH02,

     SH03,

     SH04,

     SH05,

     SH06,

     SH07,

     SH08

FROM

'..\..\..\Dashboard\SectionAccess.xlsx'

(ooxml, embedded labels, table is SHEETS);

[HirisH_V7]

Hi,

You can use the below reduction line in your script & you can add the same in excel as new column.

so that you can handle it from there ,when new requirement for any user coming in.

LOAD ACCESS,
     NTNAME,
If(NTNAME='Your User',1,0) as [Reduction Line],

FROM
'..\..\..\Dashboard\SectionAccess.xlsx'
(ooxml, embedded labels, table is SA);

By this , you can use 'Reduction line = 1 ' as the sheet condition for showing the sheet.

Hope this helps,

Hirish.V

[denis115]

what is sarep and nm?

[Anil_Babu_Samineni · Accepted solution]

May be this?

If(Match(OSUSER(), 'ntname'),1,0)

OR

If, this is from Authentication of Section Access, you could use this

if(Match(QVUSER(), 'ntname'),1,0)

[HirisH_V7]

Please check I have done a mod there.

You can use that reduction line in script and condition at sheet.

[avinashelite]

I feel your OSuser has domain attached to it .....added a text box and use =OSUser() and see how the name is displayed and then is its domain\NTNAME then use

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

[denis115]

where do I need to write expression in text box?

[avinashelite]

in the front end ....and see how your getting the value and share the same with us

[denis115]

i found