Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
PFA
Ignore the Principle tab.
-Nilesh
Hey thanks a lot Nileshh. i will check and post u..
Nilesh,
Can provide me the Excel file how ur providing access to the tabs on users..
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
I see you already have a response, perhaps another example may help you.