Sheet Properties Conditional

[robert99]

I have set up a condition as follows:-

subfield (OSUser(),'\',2) = 'hh57906'
or subfield (OSUser(),'\',2) = 'hb53567'

or subfield (OSUser(),'\',2) = 'ss56686'

Initial only user hh57906 and hb53567 had access and ss56686 was excluded. This worked as it should

I then added ss56686 but the user still can not access this file

Does anyone know why this might happen?

Thanks for any help on this.

Edit

I tried saving this file under another name That is I saved the file under a different name and gave this user right to access this file

This worked

So it seems as if something has been saved on the users computer that has set the old preferences

Message was edited by: Robert Hutchings

Message was edited by: Robert Hutchings

[#2]

I would maybe take a look and make sure that other user doesn't have different case letters,  upper() the whole statement and give that a try

Edit: Could also change the statement to a match instead

Match(Upper(subfield(osuser(),'\',2)),'HH57906','HB53567','SS56686')

hope that helps

Joe

[robert99]

Thanks

But it is lower case

I will try match and see if this amkes a difference

But it also includes for another sheet

subfield (OSUser(),'\',2) <> 'hb53567'
and subfield (OSUser(),'\',2) <> 'bb53571'
//and
//subfield (OSUser(),'\',2) <> 'ss56686'

He was excluded from this sheet but changed as follows. But he is still excluded

It seems like the initial setting can not be changed

[ThornOfCrowns]

Does Joe's MATCH statement work for you?

[joshabbott]

Maybe try to 'trim()' it?

trim(OSUser())

If this doesn't work, try to add a text object to your application with the text =

subfield(osuser(),'\',2)

Maybe something about that user is different then others, maybe it has a different domain group or something strange

[#6]

I was thinking that too Josh, the subfield is removing the domain out though, which is why I thought about maybe case, does seem like something different on that user though

[robert99 · Accepted solution]

Thanks for your suggestions

I will try the above

I have also deleted the user and added back but it still made no difference

edit This solved the problem. I just had to wait for the quarantine period to expire and remove the user completely. And then log them back on

It seems for some reason that the user settings are locked

I have not had this problem before. That is I have changed other users settings