how to assign tab wise access to the user by using section access..?

[#1]

Hi Guyss,

I hope everybody doing well.. i have got requirement goes like below. Thanks in advance..

how to assign tab wise access to the user by using section access..?

Mohan..

[nilesh_gangurde]

PFA

Ignore the Principle tab.

-Nilesh

[#3]

Hey thanks a lot Nileshh. i will check and post u..

[#4]

Nilesh,

Can provide me the Excel file how ur providing access to the tabs on users..

[nilesh_gangurde]

Hi,

USERID	Sheet1	Sheet2
A	1	1
B	0	1
C	1	0

The excel is like above example.

The User which you want to give access for perticular sheet place 1 else you can place 0.

in the above example

A can see both Sheet1 and Sheet2.

B can see only sheet 2

C can see only sheet1.

hope this will help.

-Nilesh

[Carlos_Reyes]

I see you already have a response, perhaps another example may help you.

Sheets Security with Section Access