section access to hide tabs

[#1]

Hi,

How can I use section access script to control access to application tabs for different users?

Example will be really appreciated!

Thanks,

Prashant

[SunilChauhan]

here is what u want

section Access;

Load * inline  [

Access,UserID,Password,SHEETID

Admin,sunil,sunil,*

user,sumit,sumit,SH01

user,vishesh,vishesh,SH02

];

section Application;

Load

SHEETID, // Required to be in capital

.

.

.

from path;

and in document properties->

check initial reduction based on section access

in general of ur tab-> check conditional -> count( 'SH01')>1

thanks

Sunil Chauhan

[Sokkorn]

Hi Prashant,

Check my attached file for your reference.

Regards,

Sokkorn

[#4]

but I have 35 users and 21 sheets

ur solution is becoming laborious thing to maintain....

is there any alternative?

[#5]

can you use this section access along with initial load reduction with strict exclusion.  I am using section access to reduce data by values in specific fields like Project Manager.  can I add the hide tab section access to this same load script