Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
Please help me to set access permission for document's sheets.
Ex: I have 1 document contains 3 Sheets: A, B, C and 2 users X, Y have permission to access this document. I want to set permission for user to sheets that they can be access. X just access sheet A and C, Y just access A and B.
How can I do that?
With current information that I know then I will write VB script to implement that requirement but I do not how to write it. Please help me.
Thanks,
Tai.
Hi,
Try this.
Go to sheet properties -> in general tab -> click show conditional -> type "=if(QVUser() = 'X',1,0)"
Do this in every sheet.
Here when user is it will show the sheet is user is not X it wont show sheet.
Regards,
Kaushik Solanki
Hi,
Try this.
Go to sheet properties -> in general tab -> click show conditional -> type "=if(QVUser() = 'X',1,0)"
Do this in every sheet.
Here when user is it will show the sheet is user is not X it wont show sheet.
Regards,
Kaushik Solanki
Hi,
It worked.
Many thanks,
Tai
Does this work with AJAX browsers too?