sheet level security

[ssriramin19]

Hello everyone,

This is my requirement  . In a dashboard  I have total six sheets. Sheet names are

Home, study, supplier,Services ,Qualifications Status,admin .

There are three security groups being created for this purpose,

1.CSTP-Public Report-Prod  - Users part of this group would be able to see sheets till services .

2. CSTP-Qualification Report-Prod - User part of this group would be able to see sheets till Qualifications .

3.CSTP-Admin-Prod - User part of this group would be able to see all the sheets .

Can any one please tell me how to implement security in sheets according to groups being created .

Thanks

Sriram

[ssriramin19]

can anyone please tell me how to implement sheet level security?

[ssriramin19]

Can any one please help me how to achieve the security with the above requirements.

Thanks

Sriram

[Anonymous]

Hi

You need to create excel for sheet level security:

User  SheetID

XYZ    1

ABC    0

And load in your script after that put sheet level condition in sheet properties that sheetID>0.

Thanks

[shiveshsingh]

You can implement it by marking required sheets as 1 for the group you want to display and rest as 0.

please refer Sheet Level Security.qvw