Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All.
I am want to put some security into my model. I am amble to give section access but can someone please help me with tab access, as certain people only need to view certain tabs. I have tried the following
Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD, SHEETS
ADMIN, ADMIN, ADMIN123, *
USER, USER1, 1, SH01,
USER, USER1, 1, SH03
USER, USER2, 2, SH06
USER, USER3, 3, SH04
];
Section Application;
and
Section Access;
LOAD * INLINE [
ACCESS, USERID, GROUP
ADMIN, ADMIN1, GROUP1
USER, USER1, GROUP2
USER, USER2, GROUP3
];
Section Application;
LOAD * INLINE [
GROUP, Sheets, flag
GROUP1,SH01, 1
GROUP1,SH02, 0
GROUP2,SH01, 0
GROUP2,SH02, 1
GROUP3,SH01, 1
GROUP3,SH02, 1
];
Thank you
go thru below link, might help
Hi Jean,
your code looks OK , what is the condition your using in the sheet properties to show and hide the tab??
can you please share that as well.
sum(SH01)>=1
try like this:
sum({<Sheets={'SH01'}>}flag)>=1
follow same for other sheets change SH01 to SH02 etc
or try like
if(Sheets='SH01' and flag=1,1,0)