Permission to view sheet / Button

[#1]

Hi,

I've got a document where the users navigate between sheets through text boxes with actions,

I want that only certain users can view the textbox that move to sheet and sheet herself.

how can I do that?

Attaching example.

Thanks!

[Bill_Britt]

Hi Jacob,

You could do this with section access. Not sure of other ways.

Bill

[alexandros17]

Hi,

a simple solution is with OsUser(), this function (try it in a text box) return the logged user.

You can enable the sheet navigation comparing OsUser() with a list of users enabled to perform the action.

Let me know

[stigchel · Accepted solution]

You can do this with section Access, something like this

//Table with users, NTNAME are their OS login ID's

//In ACCESGROUP you assign some value e.g. YES/NO to each user who can see sheet2

Section Access;

Load NTNAME, ACCESS, ACCESSGROUP

from users;

//link to your data

Section Application;

Load * inline [ACCESGROUP

YES

NO

];

Then in the layout properties of your textbox/button put ACCESSGROUP='YES' in the conditional show

[Bill_Britt]

Hi Alessandro,

Yes, this will work, but a smart user will find a way to bypass it. Section Access would be the best way.

Bill

[#6]

The post above by Piet Hein van der Stigchel will work, this is how i have implemented this kind of thing for clients.

[PradeepReddy]

Please find the attached application.

User Access Info

ACCESS	USERID	PASSWORD	GROUP
ADMIN	admin	admin	*
USER	User1	User1	GROUP1
USER	User2	User2	GROUP2

Sheet access Info

GROUP	Report1	Report2
GROUP1	1	0
GROUP2	0	1

Hidden Script pwd : 123

In short,

User1 has accessto Only Report1

User2 has accessto Only Report2

Admin has access to all reports.

Regards,

Pradeep

[Bill_Britt]

Hi Pradeep,

This is the way I would do it.

Bill