Tab Access security

[Anonymous]

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

[manojkulkarni]

go thru below link, might help

Sheets Security with Section Access

[avinashelite]

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.

[Anonymous]

sum(SH01)>=1

[avinashelite]

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)