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)
it also doesnt work
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);
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
what is sarep and nm?
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)
Please check I have done a mod there.
You can use that reduction line in script and condition at sheet.
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)
where do I need to write expression in text box?
in the front end ....and see how your getting the value and share the same with us
i found