Confused about using Active Directory Groups to allow access to sheets

[brf10043]

I apologize if I missed this somewhere in the community.

I have a QV document with 2 sheets.  1 sheet called "Summary" should be open to everyone.  The other sheet call "Analysis" should only be accessible to the members of an active directory group called SG-IRIS-AVIP on the WMSERVICE Domain

There are many hundreds of people in the SG-IRIS-AVIP group so I'm hoping that I don't have to maintain a mapping document somewhere but read in the Active Directory group as a unit.

I also have a different Active Directory group for Admin users that should have full access to the entire document.  This group is called SG-GRCIT_Reporting_ADMIN and is also on the WMSERVICE Domain

I'm sure someone has done this before.  Any examples would be much appreciated!

[maxgro]

try this post

Sheet Section Access by Group

[brf10043]

I think I have this working pretty well.  Thanks for your help.

Is there a way to have one of the sheets open to everyone with no Section Access?  In other words, I want one sheet to be available to everyone one in the domain and both sheets to be available if you are in the "SG-IRIS-AVIP" group.  Is that possible?  Is there a way to define access for one of the sheets for everyone in the domain?

[maxgro]

try without conditional show in the sheet you want open to everyone