sheet security access

[#1]

Hi everyone,

I am trying to limit sheet access to a selection of users. I already have an permissions tab in the script to enable access to the complete document.

In sheet properties I was trying to use this in conditional : qvuser() = username

I thought this worked but when it went to the server it did not seem to do so.

Can anyone shed some light on this?

Thanks for the help

bc

[Oleg_Troyansky]

If you already have Section Access, you can link your users to an additional "Group" field and then condition the tabes based on the Group. See example in the Chapter 30.8 in the Reference Manual

Oleg

[#3]

QVUser can work.

My section access is based on OSUser, so my conditional sheet access formula is:

IF(OSUser( ) = 'Username', 1, 0)

The problem with this solution that if you have more than 1 user you want to show the sheet to, you have to nest an 'if' statement for all of them. I have 4 people I want to show all sheets to, and even this was cumbersome to set up.

I am going to try the other suggested solution first.

[#4]

Try with:

UPPER(MATCH(qvuser(),'USER1','USER2','USER3'))

Tchau

[#5]

Hi

Please find the attachment. Hope it helps you lot