Want to hide sheets from being accessed by user

[renjithpl]

Hi,

I dont want one of my user to access certain sheets in my qvw file. I used section access for different user, but i dont know how to hide sheets for different user.

When a user logs in using userid and pwd, some sheets should be hidden.

Regards

Ranjit

[#2]

Hi,

Hope this will help you.

Thanks & Regards

[#3]

Thank you upendra

[#4]

I am unable to unrar your file.

You could create a field in your users table, something like ShowTabs. Everyone would have a 1 there, except the user in question.

Since your Security Table will not be available after Section Access is used, I would reload the contents of your Security table into another table and Qualify it.

Something like:

SecurityTable:
Load ...
Qualify *;
AccessTable:
Load * Resident SecurityTable;
Unqualify *;

Then on your charts Conditional Show, use: AccessTable.ShowTabs = 1.

[chadwatson]

Thanks! This is helpful!

[maxgro]

an example in my attachment here

Re: How to hide sheet from users?

[vijayit43]

Use this code in script where 1 show page and 0 hide page

REPLACE LOAD * INLINE [

    USER,        PAGE01,    PAGE02,    PAGE03,    PAGE04

    XXXXX,        1,        1,        1,        1

    USERID,        1,        1,        1,        0

[ashfaq_haseeb]

Hi,

Check this too.

Sheet level access

Regards

ASHFAQ