Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want certain users to access certain sheets based on their login NTNAME
I have tried adding the name of the sheets but the security does not work, what am I missing?
Thanks for your help in advance
Rick
Section Access;
security:
LOAD * INLINE [
ACCESS, NTNAME
user,B12A\ARORAR
];
Section Application;
SheetAccess:
LOAD * Inline [
NTNAME, Main,SH02
B12NA\ARORAR ,1,0];
you are basically toggling sheet visibility using conditional show and the value you specify for that sheet
The 1's means true and 0's mean false
so for example your sheet name is say "SHEET1"
and in section access you've specified access for user ABC to sheet "sh1" = 1 ;
NTNAME,sh1
ABC,1
set conditional for SHEET1 = sh1
now sh1 value for ABC = 1 which means show the Sheet1 for ABC
Read this post
I have tried this as you will see in the code in my post, it simply does not work.
it works if you do it correctly!
have you set the variable in Sheet Properties >> Show Sheet >> Conditional = SH02 ?
also have you checked this box ?
Settings > Document Settings >> Opening >> Initial data reductions & Strict exclusion
Hope you have enabled Strict Exclusion option under
Settings > Document Settings >> Opening >> Initial data reductions.
Please uncheck the option and check. as we are not reducing any data, just hiding the sheet, we don't need to check the Strict Exclusion.
Thanks for the setting check - yes i did that
why would i want to do the following? Sheet Properties >> Show Sheet >> Conditional = SH02
The sheets name is SHO2 why do I need to show conditional with =SH02 ??
Rick
In your example you have 2 sheets I hope. you need to enable conditional show for two sheets.
In Main Sheet you need add Main and in SH02 you need to add SH02, so that the user B12NA\ARORAR can see Main Sheet and not SH02.
you are basically toggling sheet visibility using conditional show and the value you specify for that sheet
The 1's means true and 0's mean false
so for example your sheet name is say "SHEET1"
and in section access you've specified access for user ABC to sheet "sh1" = 1 ;
NTNAME,sh1
ABC,1
set conditional for SHEET1 = sh1
now sh1 value for ABC = 1 which means show the Sheet1 for ABC
this post has link to most of the Section Access thread that you may find useful