Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
use match:
=Match(qvuser(),'user1','user2')
Thanks, works great......
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?
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
NOT MATCH(....)
HTH Peter
Thanks Peter, it works!