Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
I attechment my Application please could some one help me
its not working sheet level security password ADMIN
Best Regards,
Niranjan
What do you want?
Hi Sujeet, if i login with user credentials i will see only sheet1 or sheet2 or sheer3 i need to hide the sheets only admin can see all sheets Thanks In Advance Niranjan
See page 17, it could interest you the way they handle sheet security
It is an old document, but interesting
Fabrice
Hi jagan , please check the application its not working Regards, Niranjan
Hi,
It is working,
If you login as A, then you can see both Sheet1 and Sheet2.
If you login as B, then you can see only Sheet1.
If you login as C, then you can see only Sheet2.
If you login as D, then you can see both Sheet1 and Sheet2.
Try like this by login with various user ids and you will find the difference.
Regards,
Jagan.
I use the Conditional show within the tab properties with the following..
=lower(OSUSER())='xxx\xxxxxx' or lower(OSUSER())='xxx\yyyyyy'
Works for me.