Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Can someone help me with the section access for a particular sheet.
I have made an inline table with access, ntname and password
also the sheet which i want to hide for the USER , there in the sheet properties I tried a conditional show - > =OSUser()
But its not working for me. The USER is still able to see that sheet.
Thanking everyone in anticipation
Have you check what OSUser() shows on this user? Condition 'Username'<>OSUser() to hide it. In document setting under security deactivate show all objects.
its showing me the correct user. but hiding of sheet is not taking place. Do i need to add a 'Sheet Id'column in section access script and make its value as 1 or 0 for a particular user.? will that work ?