Access Permission - Please help

[#1]

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.

[kaushiknsolanki · Accepted solution]

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

[#3]

Hi,

It worked.

Many thanks,

Tai

[#4]

Does this work with AJAX browsers too?