Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi EveryOne,
I need one help, i have 3 sheets..
i want to see all sheets(Sheet1, sheet2 and sheet3), but if anyone use this application they will see only 2 sheets(sheet1 and sheet2).
is there any solution???
Use Sheet level access
without section access.. is it possible??
using OS user like..???
Hi Paul,
As per my knowledge it won't be possible.
Thank you.
Yes Possible
use QVUser() or OSUser() function
ex:
QvUser() = 'Domain\UserName'
please can you give example
on Sheet3
replace domain\user with your user

but this can be changed by other users (it depends on security properties)
Hi EveryOne,
Suppose i have ACCESS, NTNAME some other field's
then how to give Sheet level security??
I have many number of User's, but one person want to see all sheets include sheet3 also.
how to achieve this??