Button with pass word enter to access certain page

[paulyeo11]

Hi All

I have a sheet which is important information only access by top mgt people , and when user click the button , it will ask for pass word . may i know how to do it ?

Paul

[#2]

The sheet will be closed when the password will be deleted or enetered incorrectly.

Whenever user closes the document the password will clear itself if u save the document with empty password and next time he will open the document he need to insert password again.

[#3]

If u use the same text color as background color (i.e. white) , the password will be invisible after it is entered.

[#4]

no it's test.qvw you can crack by entering 1=1

password.qvw seems more safe, probably beccause sheshele didn't use the $ caracter in the conditional test.

How is distributed your doc ?

If it is via a server and open in IE, you don't need to close the sheet or reset the password, because each time you reopen it it reset to the state you saved in in your desktop client.

If you just share your .qvw the method presented here is not safe because your users will be able to access the tab properties even without the password and open them anyway. In that case you will have to use section access.

[paulyeo11]

Hi Yad

Thank you for sharing . i use system access control , but i am not sure how to implement it for only certain sheet  ? can share with me please.

[paulyeo11]

Hi rai

why enter 1=1 is equal to 12345 ?

[paulyeo11]

good suggestion.

[#8]

look at my attached file up there, you will see how to implement it

[#9]

just try paulyeo11 you will see it is working

[#10]

In my practice I use section access as foloows:

Section Access;

LOAD ACCESS,

     NTNAME,

     ROLE

FROM

[\\Qlikview\access.xlsx]

(ooxml, embedded labels, table is ACCESS);

Section Application;

PERMISSIONS:

LOAD ROLE

FROM

[\\Qlikview\access.xlsx]

(ooxml, embedded labels, table is ROLE);

Then in Sheet properties -> Conditional I enter

= ROLE='User1' OR ROLE='User2' (and normally I add OR ISNULL(ROLE) because when u reload document it clear the ROLE)

[paulyeo11]

i try closed the qv doc and open again the important sheet does not close by itself.