QVUser()

[tigerfan81]

I have 4 seperate users that need access to certain sheets. I am currently utilized the sheet conditional statement  =qvuser()='user1'.

How would you include user2 into the formula to allow user1 and user2 to have access to the sheet?

Thanks in advance for your help....

[#2 · Accepted solution]

use match:

=Match(qvuser(),'user1','user2')

[tigerfan81]

Thanks, works great......

[#4]

I tried this and so far it hasn't worked.  I made a varable too with =qvuser() as the code and it doesn't give a user.  I've tested on the server with IE and Ajax browsers.  Any ideas?

[#5]

And how would you go about excluding users? I have a text object that needs to be seen by all users except some. What would be the synthax for this?

Thanks,

T

[prieper]

NOT MATCH(....)

HTH Peter

[#7]

Thanks Peter, it works!