Sheet selections based on user

[#1]

Good Day,

i wonder if anyone can assist me, i am trying to create a sheet were depending on user the current selections is locked.

ie user 1 = group 1

user2 = group 2

i am currently doing it with trigger but need to add more users to specific sheet with different selections as currently only one user has access.

thank you

Kallie

[Anonymous]

Hi,

If I am not wrong you are trying to hide/show the sheets based on the user logged in.

In that case I would suggest you to use section access at sheet level.

Section Access - Hide Sheet Level

Sheets Security with Section Access File

Sheet level access

Hope this helps.

[#3]

Hi,

It is yes and no.

I have designed the section access depending on user. But no the need has arisen that on this particular sheet I need to restrict them even more.

Sheet 20

user1 sees group 2

user2 sees group 2

we have section access setup for the users. Ie

ACCESS, NTNAME , SP ,

USER, JOHNNY ,"*"

USER, STEFAN ,SP1

USER, DIRK ,SP2

]

SP, SALMAN_CD

SP1, 01

SP2, 02

But now the need has arisen to on certain sheets give them only SP Access according to SECTION ACCESS. But now I need to add group in their

Ie Johhny can see everything

but Stefan must be able to see group 1 and SP1

Dirk must only be able to see GROUP 2 and SP2

Which in essence will be clashing because group 2 can have a SP1 or a SP2 or how would I do that.

I thought of user based automatic selections

Ie Stefan opens sheet group1 is automatically selected on sheet and locked.

Dirk opens sheet and group2 is automatically selected on sheet and locked etc.

But not sure in which direction to go

Not sure if you are able to assist in this regard.

Thank you

Kallie

[Anonymous]

Hi Kallie,

I am not clear on your requirements.

Have few question-

• How are you creating these groups?. What does Group1 consists of and Group2?
• Is User1 and User2 related to the same group i.e. Group2? And what are these User1 and User2? (Stephen & Dirk in your table?)
• How are these User1&2, Sp1&2 and Group1&2 related.

Few things I can suggest for sheet level access is to create a separate table under "Section Application" section (below Section Access table)

Section Access;

---

---

---

;

Section Application;

LOAD * INLINE [

USERID(or NTNAME), SHEET01,SHEET2

Stephen,1,0

Dirk,1,1

];

Here Stephen will only have access to SHEET01 and Dirk can access SHEET01 and SHEET2.

You can create your own table based on your requirements.

Hope this helps.

Thanks and Regards,

Laxmi