through Section access give the permission to multiple sheets

[sreeni_qvd]

Hi All,

I have 4 sheets. and 5 users 1. ADMIN, 2. USER1, 3.USER2, 4. USER3, 5. USER4

1. ADMIN can access to see the all sheets

2. User1 can access to the only sheet1, sheet2

3. User2 can access to the only sheet2, sheet3

4. User3 can access to the only sheet1, sheet4

5, user4 can access to the only sheet1.

Please help any one how to resolve this problem.

Regards:

Sreeni

[Anonymous]

Hi Sreeni

refer below link

Section Access - Hide Sheet Level

Thanks

BKC

[buzzy996]

use this way,

User Based Access (Sheet level):

Section Access;
Load * Inline
[ACCESS,USERID,PASSWORD
ADMIN,A,X
USER,U1,Y1
USER,U2,Y2
USER,U3,Y3
USER,U4,Y4];

Section Application;
Load * Inline [
USERID,Main,Sheet1,Sheet2,Sheet3,Sheet4
A,1,1,1,1,1
U1,0,1,1,0,0
U2,0,0,1,1,0
U3,0,1,0,0,1
U4,0,1,0,0,0
];

[Anonymous]

Re: HOW TO RESTRICT SHEET ACCESS WITH SECTION ACCESS

[sreeni_qvd]

Hi Balkumarchandel Chandel,

thanks for responding my post,

Can you please give the which condition can i mention for each sheet* ,*

*send me the expression on conditional for each sheet. *

Regards:

Sreeni

On Thu, Apr 23, 2015 at 3:16 PM, balkumarchandel chandel <

[buzzy996]

with my above example u have to do on each sheet level,

On Main sheeet : sheet properties--General---Show sheet---Conditional here Main='1'

On Sheet1 sheeet : sheet properties--General---Show sheet---Conditional here Sheet1 ='1'

On Sheet2 sheeet : sheet properties--General---Show sheet---Conditional here Sheet2 ='2'

On Sheet3 sheeet : sheet properties--General---Show sheet---Conditional here Sheet3 ='3'

On Sheet4 sheeet : sheet properties--General---Show sheet---Conditional here Sheet4 ='4'

and don't forget to select,from doucment properties--opening tab

1. Initial data reduction and strictly exclusion